VIEW: APPS.PAY_HK_ASG_LEAVE_BALANCES_V

Source

View Text - Preformatted

SELECT paa.assignment_id assignment_id, paa.assignment_action_id assignment_action_id, pap.accrual_plan_id accrual_plan_id, ptp.end_date end_date, ppa.payroll_id payroll_id, pap.business_group_id business_group_id, hl.meaning accrual_units_of_measure from pay_accrual_plans pap, pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee, pay_assignment_actions paa, pay_payroll_actions ppa, per_time_periods ptp, hr_lookups hl WHERE pet.element_type_id = pap.accrual_plan_element_type_id and pel.element_type_id = pet.element_type_id and pee.element_link_id = pel.element_link_id and paa.assignment_id = pee.assignment_id and ppa.payroll_action_id = paa.payroll_action_id and ptp.payroll_id = ppa.payroll_id and pap.accrual_units_of_measure = hl.lookup_code and hl.lookup_type = 'HOURS_OR_DAYS' and ppa.date_earned between ptp.start_date and ptp.end_date and ppa.date_earned between pee.effective_start_date and pee.effective_end_date

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, PTP.END_DATE END_DATE
, PPA.PAYROLL_ID PAYROLL_ID
, PAP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HL.MEANING ACCRUAL_UNITS_OF_MEASURE
FROM PAY_ACCRUAL_PLANS PAP
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PER_TIME_PERIODS PTP
, HR_LOOKUPS HL
WHERE PET.ELEMENT_TYPE_ID = PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PAA.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
AND PAP.ACCRUAL_UNITS_OF_MEASURE = HL.LOOKUP_CODE
AND HL.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND PPA.DATE_EARNED BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE