View: HXTFV_HOURS_POLICY

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXTFV_HOURS_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
, HDP.NAME POLICY_NAME
, HDP.DESCRIPTION POLICY_DESCRIPTION
, HDP.DATE_FROM POLICY_START
, HDP.DATE_TO POLICY_END
, HR_GENERAL.DECODE_LOOKUP('HXT_HOUR_DEDUCTION_TYPE'
, HDR.FCL_DEDUCTION_TYPE) DEDUCTION_TYPE
, HDR.HOURS HOURS
, HDR.TIME_PERIOD TIME_PERIOD /*******/ /* IDS */ /*******/
, HDP.ID POLICY_ID
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_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
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AIF
, HXT_HOUR_DEDUCT_POLICIES HDP
, HXT_HOUR_DEDUCTION_RULES HDR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AIF.ASSIGNMENT_ID
AND AIF.HOUR_DEDUCTION_POLICY = HDP.ID
AND HDR.HDP_ID = HDP.ID
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
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 HDR.EFFECTIVE_START_DATE
AND HDR.EFFECTIVE_END_DATE
AND ASG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns