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.PAY_AE_PAYROLL_REGISTER dependencies on PAY_ALL_PAYROLLS_F

Line 142: from pay_all_payrolls_f

138: where ORGANIZATION_ID = l_org_id;
139: /* SELECTS BUSINESS GROUP ID FROM THE PAYROLL SPECIFIED */
140: CURSOR csr_get_bg_id_pay (l_payroll_id number , l_effective_date date) IS
141: select business_group_id
142: from pay_all_payrolls_f
143: where payroll_id = l_payroll_id
144: AND trunc(l_effective_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
145: /* SELECTS PAYROLL NAME FOR HEADER */
146: CURSOR csr_get_payroll_name(l_pyrl_id number , l_eff_date date) IS

Line 148: from pay_all_payrolls_f

144: AND trunc(l_effective_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
145: /* SELECTS PAYROLL NAME FOR HEADER */
146: CURSOR csr_get_payroll_name(l_pyrl_id number , l_eff_date date) IS
147: select payroll_name
148: from pay_all_payrolls_f
149: where PAYROLL_ID = l_pyrl_id
150: and l_eff_date between effective_start_date and effective_end_date;
151: /* SELECTS ORGANIZATION NAME FOR HEADER */
152: CURSOR csr_get_organization_name (l_org_id number) IS

Line 166: ,pay_all_payrolls_f ppf

162: ,pay_action_information pai_emp
163: ,pay_assignment_actions paa1
164: ,pay_action_interlocks lck
165: ,pay_payroll_actions ppa1
166: ,pay_all_payrolls_f ppf
167: WHERE ptp.payroll_id = l_payroll_id
168: AND ptp.time_period_id = pai_emp.action_information16
169: AND pai_emp.action_context_type = 'AAP'
170: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 188: ,pay_all_payrolls_f ppf

184: FROM per_time_periods ptp
185: ,pay_action_information pai_emp
186: ,pay_assignment_actions paa1
187: ,pay_payroll_actions ppa1
188: ,pay_all_payrolls_f ppf
189: WHERE ptp.payroll_id = l_payroll_id
190: AND ptp.time_period_id = pai_emp.action_information16
191: AND pai_emp.action_context_type = 'AAP'
192: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 213: ,pay_all_payrolls_f ppf

209: ,pay_action_information pai_emp
210: ,pay_assignment_actions paa1
211: ,pay_action_interlocks lck
212: ,pay_payroll_actions ppa1
213: ,pay_all_payrolls_f ppf
214: WHERE ptp.time_period_id = pai_emp.action_information16
215: AND pai_emp.action_context_type = 'AAP'
216: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
217: AND lck.locking_action_id = pai_emp.action_context_id

Line 245: ,pay_all_payrolls_f ppf

241: FROM per_time_periods ptp
242: ,pay_action_information pai_emp
243: ,pay_assignment_actions paa1
244: ,pay_payroll_actions ppa1
245: ,pay_all_payrolls_f ppf
246: WHERE ptp.time_period_id = pai_emp.action_information16
247: AND pai_emp.action_context_type = 'AAP'
248: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
249: AND pai_emp.action_context_id = paa1.assignment_action_id

Line 280: ,pay_all_payrolls_f ppf

276: ,pay_action_information pai_emp
277: ,pay_assignment_actions paa1
278: ,pay_action_interlocks lck
279: ,pay_payroll_actions ppa1
280: ,pay_all_payrolls_f ppf
281: WHERE ptp.time_period_id = pai_emp.action_information16
282: AND pai_emp.action_context_type = 'AAP'
283: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
284: AND lck.locking_action_id = pai_emp.action_context_id

Line 302: ,pay_all_payrolls_f ppf

298: FROM per_time_periods ptp
299: ,pay_action_information pai_emp
300: ,pay_assignment_actions paa1
301: ,pay_payroll_actions ppa1
302: ,pay_all_payrolls_f ppf
303: WHERE ptp.time_period_id = pai_emp.action_information16
304: AND pai_emp.action_context_type = 'AAP'
305: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
306: AND pai_emp.action_context_id = paa1.assignment_action_id

Line 326: ,pay_all_payrolls_f ppf

322: ,pay_action_information pai_emp
323: ,pay_assignment_actions paa1
324: ,pay_action_interlocks lck
325: ,pay_payroll_actions ppa1
326: ,pay_all_payrolls_f ppf
327: WHERE ptp.time_period_id = pai_emp.action_information16
328: AND pai_emp.action_context_type = 'AAP'
329: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
330: AND lck.locking_action_id = pai_emp.action_context_id

Line 355: ,pay_all_payrolls_f ppf

351: ,pay_action_information pai_emp
352: ,pay_assignment_actions paa1
353: ,pay_action_interlocks lck
354: ,pay_payroll_actions ppa1
355: ,pay_all_payrolls_f ppf
356: WHERE ptp.time_period_id = pai_emp.action_information16
357: AND pai_emp.action_context_type = 'AAP'
358: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
359: AND lck.locking_action_id = pai_emp.action_context_id

Line 386: ,pay_all_payrolls_f ppf

382: FROM per_time_periods ptp
383: ,pay_action_information pai_emp
384: ,pay_assignment_actions paa1
385: ,pay_payroll_actions ppa1
386: ,pay_all_payrolls_f ppf
387: WHERE ptp.time_period_id = pai_emp.action_information16
388: AND pai_emp.action_context_type = 'AAP'
389: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
390: AND pai_emp.action_context_id = paa1.assignment_action_id

Line 419: ,pay_all_payrolls_f ppf

415: ,pay_action_information pai_emp
416: ,pay_assignment_actions paa1
417: ,pay_action_interlocks lck
418: ,pay_payroll_actions ppa1
419: ,pay_all_payrolls_f ppf
420: WHERE ptp.time_period_id = pai_emp.action_information16
421: AND pai_emp.action_context_type = 'AAP'
422: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
423: AND lck.locking_action_id = pai_emp.action_context_id

Line 467: ,pay_all_payrolls_f ppf

463: ,pay_action_information pai_emp1
464: ,pay_assignment_actions paa1
465: ,pay_action_interlocks lck
466: ,pay_payroll_actions ppa1
467: ,pay_all_payrolls_f ppf
468: WHERE ptp.payroll_id = l_payroll_id
469: AND ptp.time_period_id = pai_emp.action_information16
470: AND pai_emp.action_context_id = pai_emp1.action_context_id
471: AND pai_emp.action_context_type = 'AAP'

Line 510: ,pay_all_payrolls_f ppf

506: ,pay_action_information pai_emp
507: ,pay_action_information pai_emp1
508: ,pay_assignment_actions paa1
509: ,pay_payroll_actions ppa1
510: ,pay_all_payrolls_f ppf
511: WHERE ptp.payroll_id = l_payroll_id
512: AND ptp.time_period_id = pai_emp.action_information16
513: AND pai_emp.action_context_id = pai_emp1.action_context_id
514: AND pai_emp.action_context_type = 'AAP'