View: PAY_KR_ASG_LEAVE_BALANCES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_KR_ASG_LEAVE_BALANCES_V

View Text

SELECT AA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, AA.ASSIGNMENT_ID ASSIGNMENT_ID
, AP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, AP.ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, PA.EFFECTIVE_DATE EFFECTIVE_DATE
, TP.START_DATE START_DATE
, TP.END_DATE END_DATE
, PA.PAYROLL_ID PAYROLL_ID
, AP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HL.MEANING ACCRUAL_UNITS_OF_MEASURE
, OI.ORG_INFORMATION13 LEAVE_TAKEN_DIM FROM PAY_ASSIGNMENT_ACTIONS AA
, PAY_PAYROLL_ACTIONS PA
, PAY_ACCRUAL_PLANS AP
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_LINKS_F EL
, PAY_ELEMENT_ENTRIES_F EE
, PER_TIME_PERIODS TP
, HR_LOOKUPS HL
, HR_ORGANIZATION_INFORMATION OI
WHERE ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID AND EE.ELEMENT_LINK_ID = EL.ELEMENT_LINK_ID AND AA.ASSIGNMENT_ID = EE.ASSIGNMENT_ID AND PA.PAYROLL_ACTION_ID = AA.PAYROLL_ACTION_ID AND PA.ACTION_TYPE IN ('R'
, 'Q') AND PA.ACTION_STATUS = 'C' AND TP.PAYROLL_ID = PA.PAYROLL_ID AND AP.ACCRUAL_UNITS_OF_MEASURE = HL.LOOKUP_CODE AND HL.LOOKUP_TYPE = 'HOURS_OR_DAYS' AND AA.TAX_UNIT_ID = OI.ORGANIZATION_ID AND OI.ORG_INFORMATION_CONTEXT = 'KR_BUSINESS_PLACE_REGISTRATION' AND PA.DATE_EARNED BETWEEN TP.START_DATE AND TP.END_DATE AND PA.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE AND PA.EFFECTIVE_DATE BETWEEN EL.EFFECTIVE_START_DATE
AND EL.EFFECTIVE_END_DATE AND PA.EFFECTIVE_DATE BETWEEN EE.EFFECTIVE_START_DATE
AND EE.EFFECTIVE_END_DATE

Columns