VIEW: APPS.PAY_SG_LEAVE_BALANCES_V

Source

View Text - Preformatted

SELECT pac.assignment_id, pac.assignment_action_id, ppl.accrual_plan_id, ppa.effective_date, ppa.payroll_id, ppl.business_group_id from per_absence_attendance_types pat, pay_accrual_plans ppl, pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee, pay_assignment_actions pac, pay_payroll_actions ppa, per_time_periods ptp WHERE ppl.pto_input_value_id = pat.input_value_id and pet.element_type_id = ppl.accrual_plan_element_type_id and pel.element_type_id = pet.element_type_id and pee.element_link_id = pel.element_link_id and pac.assignment_id = pee.assignment_id and ppa.payroll_action_id = pac.payroll_action_id and ptp.payroll_id = ppa.payroll_id 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 PAC.ASSIGNMENT_ID
, PAC.ASSIGNMENT_ACTION_ID
, PPL.ACCRUAL_PLAN_ID
, PPA.EFFECTIVE_DATE
, PPA.PAYROLL_ID
, PPL.BUSINESS_GROUP_ID
FROM PER_ABSENCE_ATTENDANCE_TYPES PAT
, PAY_ACCRUAL_PLANS PPL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_PAYROLL_ACTIONS PPA
, PER_TIME_PERIODS PTP
WHERE PPL.PTO_INPUT_VALUE_ID = PAT.INPUT_VALUE_ID
AND PET.ELEMENT_TYPE_ID = PPL.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PAC.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
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