View: HXC_RESOURCE_ALL_ELIG_PREF_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_RESOURCE_ALL_ELIG_PREF_V

View Text

SELECT PA.PERSON_ID
, HRR.RULE_EVALUATION_ORDER
, HRR.NAME
, HRR.BUSINESS_GROUP_ID
, HRR.LEGISLATION_CODE
, HPD.PREF_DEFINITION_ID
, HPD.CODE
, DF.DESCRIPTIVE_FLEX_CONTEXT_NAME PREFERENCE_NAME
, HPH.EDIT_ALLOWED
, HPH.DISPLAYED
, HPH.NAME
, HPH.ATTRIBUTE_CATEGORY
, HPH.ATTRIBUTE1
, HPH.ATTRIBUTE2
, HPH.ATTRIBUTE3
, HPH.ATTRIBUTE4
, HPH.ATTRIBUTE5
, HPH.ATTRIBUTE6
, HPH.ATTRIBUTE7
, HPH.ATTRIBUTE8
, HPH.ATTRIBUTE9
, HPH.ATTRIBUTE10
, HPH.ATTRIBUTE11
, HPH.ATTRIBUTE12
, HPH.ATTRIBUTE13
, HPH.ATTRIBUTE14
, HPH.ATTRIBUTE15
, HPH.ATTRIBUTE16
, HPH.ATTRIBUTE17
, HPH.ATTRIBUTE18
, HPH.ATTRIBUTE19
, HPH.ATTRIBUTE20
, HPH.ATTRIBUTE21
, HPH.ATTRIBUTE22
, HPH.ATTRIBUTE23
, HPH.ATTRIBUTE24
, HPH.ATTRIBUTE25
, HPH.ATTRIBUTE26
, HPH.ATTRIBUTE27
, HPH.ATTRIBUTE28
, HPH.ATTRIBUTE29
, HPH.ATTRIBUTE30
FROM FND_DESCR_FLEX_CONTEXTS_VL DF
, HXC_PREF_HIERARCHIES HPH
, HXC_PREF_DEFINITIONS HPD
, HXC_RESOURCE_RULES HRR
, PER_ASSIGNMENTS_F PA
WHERE DF.APPLICATION_ID =809
AND DF.DESCRIPTIVE_FLEXFIELD_NAME ='OTC PREFERENCES'
AND DF.DESCRIPTIVE_FLEX_CONTEXT_CODE = HPD.CODE
AND SYSDATE BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE
AND PA.PRIMARY_FLAG = 'Y'
AND HPH.PREF_HIERARCHY_ID IN (SELECT HPH2.PREF_HIERARCHY_ID
FROM HXC_PREF_HIERARCHIES HPH2 START WITH HPH2.PREF_HIERARCHY_ID = HRR.PREF_HIERARCHY_ID CONNECT BY PRIOR HPH2.PREF_HIERARCHY_ID = HPH2.PARENT_PREF_HIERARCHY_ID)
AND HPH.PREF_DEFINITION_ID = HPD.PREF_DEFINITION_ID
AND HRR.RESOURCE_TYPE = 'PERSON'
AND (((HRR.ELIGIBILITY_CRITERIA_TYPE = 'ALL_PEOPLE'
AND (HRR.BUSINESS_GROUP_ID IS NULL OR (HRR.BUSINESS_GROUP_ID = HPH.BUSINESS_GROUP_ID
AND HRR.BUSINESS_GROUP_ID = (SELECT BUSINESS_GROUP_ID
FROM PER_PEOPLE_F PP
WHERE PP.PERSON_ID = PA.PERSON_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE)) )) OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.PERSON_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'PERSON') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.ASSIGNMENT_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'ASSIGNMENT') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.LOCATION_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'LOCATION') OR (HRR.ELIGIBILITY_CRITERIA_ID = PA.EMPLOYEE_CATEGORY
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'EMP_CATEGORY') OR (HRR.ELIGIBILITY_CRITERIA_ID = PA.EMPLOYMENT_CATEGORY
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'ASGN_CATEGORY') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.JOB_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'JOB') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.ORGANIZATION_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'ORGANIZATION') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.PAYROLL_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'PAYROLL') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR( PA.PEOPLE_GROUP_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'PEOPLE_GROUP') OR (HRR.ELIGIBILITY_CRITERIA_ID = TO_CHAR(PA.POSITION_ID)
AND HRR.ELIGIBILITY_CRITERIA_TYPE = 'POSITION')) OR (DECODE ( SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 1
, 3 )
, 'SCL'
, DECODE ( PA.SOFT_CODING_KEYFLEX_ID
, NULL
, -1
, HXC_RESOURCE_RULES_UTILS.CHK_FLEX_VALID ( 'SCL'
, PA.SOFT_CODING_KEYFLEX_ID
, SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 5 )
, HRR.ELIGIBILITY_CRITERIA_ID ))
, -1 ) = 1 ) OR (DECODE ( SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 1
, 6 )
, 'PEOPLE'
, DECODE ( PA.PEOPLE_GROUP_ID
, NULL
, -1
, HXC_RESOURCE_RULES_UTILS.CHK_FLEX_VALID ( 'PEOPLE'
, PA.PEOPLE_GROUP_ID
, SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 8 )
, HRR.ELIGIBILITY_CRITERIA_ID ))
, -1 ) = 1 ) OR (DECODE ( SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 1
, 5 )
, 'GRADE'
, DECODE ( PA.GRADE_ID
, NULL
, -1
, HXC_RESOURCE_RULES_UTILS.CHK_FLEX_VALID ( 'GRADE'
, PA.GRADE_ID
, SUBSTR( HRR.ELIGIBILITY_CRITERIA_TYPE
, 7 )
, HRR.ELIGIBILITY_CRITERIA_ID ))
, -1 ) = 1 ))

Columns