Product: | HXT - Time and Labor |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXTFV_EARNING_GROUPS |
SELECT /* $HEADER: HXTVIEW.LDT 115.3 2001/08/31 15:17:25 PKM SHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, 1 PERSON_COUNT
, EPL.NAME EARNING_POLICY
, PET.ELEMENT_NAME ELEMENT_NAME
, EGT.NAME EARNING_GROUP_TYPE
, EGT.DESCRIPTION GROUP_TYPE_DESCRIPTION
, HR_GENERAL.DECODE_LOOKUP('HXT_GROUP_TYPE'
, EGT.FCL_EG_TYPE) GROUP_TYPE /*******/ /* IDS */ /*******/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, EGR.EGT_ID EARNING_GROUP_TYPE_ID
, EGR.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AIF
, HXT_EARNING_POLICIES EPL
, HXT_EARN_GROUPS EGR
, HXT_EARN_GROUP_TYPES EGT
, PAY_ELEMENT_TYPES_F PET
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE ASG.PERSON_ID = PEO.PERSON_ID
AND AIF.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND AIF.EARNING_POLICY = EPL.ID
AND EPL.EGT_ID = EGT.ID
AND EGR.EGT_ID = EGT.ID
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND EGR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID)
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN AIF.EFFECTIVE_START_DATE
AND AIF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN EGT.EFFECTIVE_START_DATE
AND EGT.EFFECTIVE_END_DATE WITH READ ONLY