VIEW: APPS.PAY_NZ_ASG_LEAVE_BALANCES_V

Source

View Text - Preformatted

SELECT aa.assignment_id , aa.assignment_action_id , ap.accrual_plan_id , tp.end_date , pa.payroll_id , ap.business_group_id from pay_accrual_plans ap , pay_element_types_f et , pay_element_links_f el , pay_element_entries_f ee , pay_assignment_actions aa , pay_payroll_actions pa , per_time_periods tp 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 tp.payroll_id = pa.payroll_id and pa.effective_date 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

View Text - HTML Formatted

SELECT AA.ASSIGNMENT_ID
, AA.ASSIGNMENT_ACTION_ID
, AP.ACCRUAL_PLAN_ID
, TP.END_DATE
, PA.PAYROLL_ID
, AP.BUSINESS_GROUP_ID
FROM PAY_ACCRUAL_PLANS AP
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_LINKS_F EL
, PAY_ELEMENT_ENTRIES_F EE
, PAY_ASSIGNMENT_ACTIONS AA
, PAY_PAYROLL_ACTIONS PA
, PER_TIME_PERIODS TP
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 TP.PAYROLL_ID = PA.PAYROLL_ID
AND PA.EFFECTIVE_DATE 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