eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NZBAL dependencies on PAY_PAYROLL_ACTIONS

Line 86: , pay_payroll_actions ppa

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');
90: --

Line 122: , pay_payroll_actions ppa

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
126: WHERE paf.assignment_id = c_assignment_id

Line 209: from pay_payroll_actions ppa

205: l_effective_date date;
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: --

Line 625: /* Bug:3043157 Modified the date track join for pay_payroll_actions */

621: l_start_dd_mm varchar2(9);
622: l_effective_date date;
623: -- Bug# 2097319 Added the following cursor
624:
625: /* Bug:3043157 Modified the date track join for pay_payroll_actions */
626: /* Bug 4259438 Modified cursor for performance */
627: CURSOR get_assgt_action_id ( c_assignment_id IN NUMBER
628: , v_ann_start IN DATE
629: , v_ann_end IN DATE

Line 634: , pay_payroll_actions ppa

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
638: WHERE paf.assignment_id = c_assignment_id

Line 664: , pay_payroll_actions ppa

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
668: WHERE paf.assignment_id = c_assignment_id

Line 692: pay_payroll_actions ppa

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');
696:

Line 701: pay_payroll_actions PACTION

697: -- Bug# 2203667 Added the following cursor
698: -- Bug# 2264070 Added the join on payroll_action_id
699: cursor get_pay_period_start_date(p_assignment_id in number) is
700: SELECT TPERIOD.start_date FROM
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

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 1401: , pay_payroll_actions ppa

1397: --
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;

Line 1692: , pay_payroll_actions ppa

1688: --
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;

Line 1842: , pay_payroll_actions ppa

1838: --
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;