View: HXTFV_ELIGIBILITY_POLICY

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

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
, 1 PERSON_COUNT
, EPL.NAME EARNING_POLICY
, PEP.NAME PREMIUM_ELIGIBILITY_POLICY
, PEP.DESCRIPTION POLICY_DESCRIPTION
, PEP.DATE_FROM DATE_FROM
, PEP.DATE_TO DATE_TO
, BASE_POL.ELEMENT_NAME POLICY_BASE_ELEMENT
, BASE_RULE.ELEMENT_NAME RULES_BASE_ELEMENT
, PREM_RULE.ELEMENT_NAME RULES_PREM_ELEMENT /********/ /* IDS */ /********/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, EPR.ELT_BASE_ID BASE_POL_ID
, PER.ELT_BASE_ID BASE_RULES_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EPL.ID EARNING_POLICY_ID
, PEP.ID ELIGIBILITY_POLICY_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, PER.ELT_PREMIUM_ID PREM_RULES_ID
FROM HXT_PREM_ELIGBLTY_POLICIES PEP
, HXT_PREM_ELIGBLTY_POL_RULES EPR
, HXT_PREM_ELIGBLTY_RULES PER
, HXT_ADD_ASSIGN_INFO_F AAI
, HXT_EARNING_POLICIES EPL
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, PAY_ELEMENT_TYPES_F BASE_POL
, PAY_ELEMENT_TYPES_F BASE_RULE
, PAY_ELEMENT_TYPES_F PREM_RULE
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AAI.ASSIGNMENT_ID
AND AAI.EARNING_POLICY = EPL.ID
AND EPL.PEP_ID = PEP.ID
AND PEP.ID = EPR.PEP_ID
AND PEP.ID = PER.PEP_ID
AND EPR.ELT_BASE_ID = BASE_POL.ELEMENT_TYPE_ID (+)
AND PER.ELT_BASE_ID = BASE_RULE.ELEMENT_TYPE_ID (+)
AND PER.ELT_PREMIUM_ID = PREM_RULE.ELEMENT_TYPE_ID (+)
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
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 AAI.EFFECTIVE_START_DATE
AND AAI.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN EPR.EFFECTIVE_START_DATE
AND EPR.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN EPL.EFFECTIVE_START_DATE
AND EPL.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN BASE_POL.EFFECTIVE_START_DATE (+)
AND BASE_POL.EFFECTIVE_END_DATE (+)
AND SYSDATE BETWEEN BASE_RULE.EFFECTIVE_START_DATE (+)
AND BASE_RULE.EFFECTIVE_END_DATE (+)
AND SYSDATE BETWEEN PREM_RULE.EFFECTIVE_START_DATE (+)
AND PREM_RULE.EFFECTIVE_END_DATE (+) WITH READ ONLY

Columns