APPS.HR_NZBAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 85: from pay_assignment_actions paa

81: l_assignment_id number;
82: --
83: cursor get_corr_type ( c_assignment_action_id in number ) is
84: select assignment_id
85: from pay_assignment_actions paa
86: , pay_payroll_actions ppa
87: where paa.assignment_action_id = c_assignment_action_id
88: and ppa.payroll_action_id = paa.payroll_action_id
89: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 121: FROM pay_assignment_actions paa

117: , c_effective_date IN DATE
118: )
119: IS
120: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
121: FROM pay_assignment_actions paa
122: , pay_payroll_actions ppa
123: , per_assignments_f paf
124: , pay_payrolls_f ppf
125: , per_time_periods ptp

Line 210: , pay_assignment_actions paa

206: --
207: cursor c_bal_date is
208: select ppa.effective_date
209: from pay_payroll_actions ppa
210: , pay_assignment_actions paa
211: where paa.payroll_action_id = ppa.payroll_action_id
212: and paa.assignment_action_id = p_assignment_action_id;
213: --
214: begin

Line 324: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

320: --
321: return number
322: is
323: --
324: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
325: --
326: begin
327: --
328: -- Bug 3181581

Line 633: FROM pay_assignment_actions paa

629: , v_ann_end IN DATE
630: )
631: IS
632: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
633: FROM pay_assignment_actions paa
634: , pay_payroll_actions ppa
635: , per_assignments_f paf
636: , pay_payrolls_f ppf
637: , per_time_periods ptp

Line 663: FROM pay_assignment_actions paa

659: , c_effective_date IN DATE
660: )
661: IS
662: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
663: FROM pay_assignment_actions paa
664: , pay_payroll_actions ppa
665: , per_assignments_f paf
666: , pay_payrolls_f ppf
667: , per_time_periods ptp

Line 691: from pay_assignment_actions paa,

687:
688: cursor get_dates (c_assignment_action_id in number)
689: is
690: select ppa.date_earned,ppa.effective_date
691: from pay_assignment_actions paa,
692: pay_payroll_actions ppa
693: where paa.assignment_action_id = c_assignment_action_id
694: and ppa.payroll_action_id = paa.payroll_action_id
695: and ppa.action_type in ('R','Q','I','V','B');

Line 705: from pay_assignment_actions paa,pay_payroll_actions ppa

701: pay_payroll_actions PACTION
702: , per_time_periods TPERIOD
703: , per_time_period_types TPTYPE
704: where PACTION.payroll_action_id = (select max(paa.payroll_action_id)
705: from pay_assignment_actions paa,pay_payroll_actions ppa
706: where paa.assignment_id=p_assignment_id
707: and ppa.action_type in ('R','Q')
708: and ppa.payroll_action_id = paa.payroll_action_id )
709: and PACTION.payroll_id = TPERIOD.payroll_id

Line 1402: , pay_assignment_actions paa

1398: cursor expired_time_period (c_assignment_action_id number) is
1399: select ptp.end_date
1400: from per_time_periods ptp
1401: , pay_payroll_actions ppa
1402: , pay_assignment_actions paa
1403: where paa.assignment_action_id = c_assignment_action_id
1404: and paa.payroll_action_id = ppa.payroll_action_id
1405: and ppa.time_period_id = ptp.time_period_id;
1406: --

Line 1693: , pay_assignment_actions paa

1689: cursor expired_time_period ( c_assignment_action_id in number ) is
1690: select ptp.end_date
1691: from per_time_periods ptp
1692: , pay_payroll_actions ppa
1693: , pay_assignment_actions paa
1694: where paa.assignment_action_id = c_assignment_action_id
1695: and paa.payroll_action_id = ppa.payroll_action_id
1696: and ppa.time_period_id = ptp.time_period_id;
1697: --

Line 1843: , pay_assignment_actions paa

1839: cursor expired_time_period( c_assignment_action_id in number ) is
1840: select ptp.end_date
1841: from per_time_periods ptp
1842: , pay_payroll_actions ppa
1843: , pay_assignment_actions paa
1844: where paa.assignment_action_id = c_assignment_action_id
1845: and paa.payroll_action_id = ppa.payroll_action_id
1846: and ppa.time_period_id = ptp.time_period_id;
1847: --