Country transffer

SELECT PART_DTLS.PARTICIPANT_ID "PARTICIPANT_ID", PART_HDR.PARTICIPANT_NAME PARTICIPANT_NAME, -- PART_DTLS.PARTICIPANT_DETAIL_ID "PARTICIPANT_DETAIL_ID", -- PART_DTLS.ORG_ID "ORG_ID", -- PART_DTLS.START_DATE "START_DATE", -- PART_DTLS.END_DATE "END_DATE", -- PART_DTLS.COUNTRY_CODE HR_Country, -- PART_DTLS.ATTRIBUTE_CHAR40 Employment_Country, -- PART_DTLS.ATTRIBUTE_NUMBER1 "HR_TI", -- PART_DTLS.CURRENCY_CODE "HOME_CURRENCY", -- PART_DTLS.ATTRIBUTE_CHAR2 HR_Status, -- PART_DTLS.ATTRIBUTE_CHAR17 SalesRep, -- PART_DTLS.ATTRIBUTE_CHAR33 ActionCode, cpb.period_id FROM CN_SRP_PARTICIPANT_DETAILS_ALL PART_DTLS JOIN CN_SRP_PARTICIPANTS_ALL PART_HDR ON PART_DTLS.PARTICIPANT_ID = PART_HDR.PARTICIPANT_ID AND PART_DTLS.ORG_ID = PART_HDR.ORG_ID JOIN CN_PERIODS_B CPB on CPB.START_DATE >= PART_DTLS.START_DATE and CPB.START_DATE <= PART_DTLS.END_DATE --and PART_HDR.participant_id = 300000472439641 group by cpb.period_id , PART_HDR.PARTICIPANT_NAME , PART_DTLS.PARTICIPANT_ID having count(1) > 1

Comments

Popular posts from this blog

dev7 from eror

EPA

Unified Currency Report- Krithika