View: HXTFV_ADD_ASSIGN_INFO

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXTFV_ADD_ASSIGN_INFO

View Text

SELECT /* $HEADER: HXTVIEW.LDT 115.3 2001/08/31 15:17:25 PKM SHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HEP.NAME EARNING_POLICY
, HEP.DESCRIPTION EARNING_POLICY_DESCRIPTION
, HRP.NAME ROTATION_PLAN
, HRP.DESCRIPTION ROTATION_PLAN_DESCRIPTION
, SDP.NAME SHIFT_DIFFERENTIAL_POLICY
, SDP.DESCRIPTION SHIFT_POLICY_DESCRIPTION
, HDP.NAME HOUR_DEDUCTION_POLICY
, HDP.DESCRIPTION HOUR_POLICY_DESCRIPTION
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, AIF.AUTOGEN_HOURS_YN) AUTOGEN_FLAG
, AIF.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, '_DF:HXT:HXT_ADD_ASSIGN_INFO_F:AIF' /*******/ /* IDS */ /*******/
, AIF.ID ASSIGNMENT_INFO_ID
, AIF.ASSIGNMENT_ID ASSIGNMENT_ID
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, AIF.EARNING_POLICY EARNING_POLICY_ID
, ASG.GRADE_ID GRADE_ID
, AIF.HOUR_DEDUCTION_POLICY HOUR_POLICY_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, PEO.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, AIF.ROTATION_PLAN ROTATION_PLAN_ID
, AIF.SHIFT_DIFFERENTIAL_POLICY SHIFT_POLICY_ID
FROM HXT_ADD_ASSIGN_INFO_F AIF
, HXT_EARNING_POLICIES HEP
, HXT_ROTATION_PLANS HRP
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_HOUR_DEDUCT_POLICIES HDP
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE SYSDATE BETWEEN AIF.EFFECTIVE_START_DATE
AND AIF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN HEP.EFFECTIVE_START_DATE
AND HEP.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AIF.ASSIGNMENT_ID
AND AIF.EARNING_POLICY = HEP.ID
AND AIF.ROTATION_PLAN = HRP.ID (+)
AND AIF.SHIFT_DIFFERENTIAL_POLICY = SDP.ID (+)
AND AIF.HOUR_DEDUCTION_POLICY = HDP.ID (+)
AND PEO.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns