View: HXT_EMP_ASGN_INFO_V

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

View Text

SELECT PA.ASSIGNMENT_ID
, PA.ASSIGNMENT_NUMBER
, PA.EFFECTIVE_START_DATE
, PA.EFFECTIVE_END_DATE
, PA.BUSINESS_GROUP_ID
, BG.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME
, PER.LAST_NAME
, PER.FIRST_NAME
, PER.EMPLOYEE_NUMBER
, PAY.PAYROLL_NAME
, OT.NAME ORGANIZATION_NAME
, PAFV.HXT_AUTOGEN_HOURS_YN
, EP.NAME EARNING_POL_NAME
, RP.NAME ROTATION_PLAN_NAME
, SD.NAME SHIFT_DIFF_POL_NAME
, HDP.NAME HOUR_DEDUCT_POL_NAME
, EGT.NAME EARN_GROUP_TYPE_NAME
, PIP.NAME PREM_INTERACT_POL_NAME
, PEP.NAME PREM_ELIGBLTY_POL_NAME
, HCL.NAME HOLIDAY_CALENDAR_NAME
FROM PER_ASSIGNMENTS_F PA
, HXT_PER_AEI_DDF_V PAFV
, PER_BUSINESS_GROUPS BG
, PER_ALL_PEOPLE_F PER
, PAY_ALL_PAYROLLS_F PAY
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OT
, HXT_EARNING_POLICIES EP
, HXT_ROTATION_PLANS RP
, HXT_SHIFT_DIFF_POLICIES SD
, HXT_HOUR_DEDUCT_POLICIES HDP
, HXT_EARN_GROUP_TYPES EGT
, HXT_PREM_INTERACT_POLICIES PIP
, HXT_PREM_ELIGBLTY_POLICIES PEP
, HXT_HOLIDAY_CALENDARS HCL
, FND_SESSIONS F
WHERE PA.ASSIGNMENT_TYPE = 'E'
AND PA.ASSIGNMENT_ID = PAFV.ASSIGNMENT_ID
AND F.EFFECTIVE_DATE BETWEEN PAFV.EFFECTIVE_START_DATE
AND PAFV.EFFECTIVE_END_DATE
AND PA.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID(+)
AND PA.PERSON_ID = PER.PERSON_ID(+)
AND PA.PAYROLL_ID = PAY.PAYROLL_ID(+)
AND PA.ORGANIZATION_ID = O.ORGANIZATION_ID
AND OT.ORGANIZATION_ID = O.ORGANIZATION_ID
AND OT.LANGUAGE = USERENV('LANG')
AND PAFV.HXT_EARNING_POLICY = EP.ID(+)
AND PAFV.HXT_ROTATION_PLAN = RP.ID(+)
AND PAFV.HXT_SHIFT_DIFFERENTIAL_POLICY = SD.ID(+)
AND PAFV.HXT_HOUR_DEDUCTION_POLICY = HDP.ID(+)
AND EP.EGT_ID = EGT.ID(+)
AND EP.PIP_ID = PIP.ID(+)
AND EP.PEP_ID = PEP.ID(+)
AND EP.HCL_ID = HCL.ID(+)
AND F.SESSION_ID = USERENV('SESSIONID')
AND F.EFFECTIVE_DATE BETWEEN NVL(PA.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(PA.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(PER.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(PER.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(PAY.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(PAY.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(EP.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(EP.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(RP.DATE_FROM
, F.EFFECTIVE_DATE)
AND NVL(RP.DATE_TO
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(SD.DATE_FROM
, F.EFFECTIVE_DATE)
AND NVL(SD.DATE_TO
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(HDP.DATE_FROM
, F.EFFECTIVE_DATE)
AND NVL(HDP.DATE_TO
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(EGT.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(EGT.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(PIP.DATE_FROM
, F.EFFECTIVE_DATE)
AND NVL(PIP.DATE_TO
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(PEP.DATE_FROM
, F.EFFECTIVE_DATE)
AND NVL(PEP.DATE_TO
, F.EFFECTIVE_DATE)
AND F.EFFECTIVE_DATE BETWEEN NVL(HCL.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(HCL.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE)

Columns