APPS.HR_NZ_HOLIDAYS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1440: , pay_assignment_actions aa

1436: from per_absence_attendances ab
1437: , per_absence_attendance_types aat
1438: , pay_element_entries_f ee
1439: , pay_run_results rr
1440: , pay_assignment_actions aa
1441: , pay_payroll_actions pa
1442: , per_time_periods tp
1443: where aat.absence_attendance_type_id = ab.absence_attendance_type_id
1444: and aat.absence_category in ('NZSL', 'NZVS')

Line 1649: from pay_assignment_actions paa,

1645: per_time_periods TPERIOD,
1646: per_time_period_types TPTYPE
1647: where PACTION.payroll_action_id =
1648: (select max(paa.payroll_action_id)
1649: from pay_assignment_actions paa,
1650: pay_payroll_actions ppa
1651: where paa.assignment_id = p_assignment_id
1652: and ppa.action_type in ('R','Q')
1653: and ppa.payroll_action_id = paa.payroll_action_id)

Line 2047: from pay_assignment_actions paa,

2043: per_time_periods TPERIOD,
2044: per_time_period_types TPTYPE
2045: where PACTION.payroll_action_id =
2046: (select max(paa.payroll_action_id)
2047: from pay_assignment_actions paa,
2048: pay_payroll_actions ppa
2049: where paa.assignment_id = p_assignment_id
2050: and ppa.action_type in ('R','Q')
2051: and ppa.payroll_action_id = paa.payroll_action_id)

Line 2106: , pay_assignment_actions aa -- assignment action for -- absence element entry

2102: -- "hours taken" entry value
2103: , pay_element_entries_f ee -- absence element entry
2104: , pay_run_results rr -- run result for absence -- element entry
2105: , per_absence_attendances ab -- absence record
2106: , pay_assignment_actions aa -- assignment action for -- absence element entry
2107: , pay_payroll_actions pa -- payroll action for -- absence element entry
2108: , per_time_periods tp
2109: , pay_run_results rr2 -- run result for Annual -- Leave Pay element type
2110: , pay_run_result_values rrv2 -- run result value for -- Annual Leave Pay element -- pay value ,

Line 3555: from pay_assignment_actions paa,

3551: per_time_periods TPERIOD,
3552: per_time_period_types TPTYPE
3553: where PACTION.payroll_action_id =
3554: (select max(paa.payroll_action_id)
3555: from pay_assignment_actions paa,
3556: pay_payroll_actions ppa
3557: where paa.assignment_id = p_assignment_id
3558: and ppa.action_type in ('R','Q')
3559: and ppa.payroll_action_id = paa.payroll_action_id)

Line 3641: ,pay_assignment_actions pac

3637: cursor c_get_values(p_assignment_id number) is
3638: select max(ppa.effective_date)
3639: ,ppa.payroll_id
3640: from pay_payroll_actions ppa
3641: ,pay_assignment_actions pac
3642: where pac.assignment_id = p_assignment_id
3643: and pac.payroll_action_id = ppa.payroll_action_id
3644: and ppa.action_type = 'L'
3645: group by ppa.payroll_id ;