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_KW_PAYROLL_REGISTER dependencies on PAY_ALL_PAYROLLS_F

Line 144: from pay_all_payrolls_f

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

Line 150: from pay_all_payrolls_f

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

Line 168: ,pay_all_payrolls_f ppf

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

Line 190: ,pay_all_payrolls_f ppf

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

Line 214: ,pay_all_payrolls_f ppf

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

Line 246: ,pay_all_payrolls_f ppf

242: FROM per_time_periods ptp
243: ,pay_action_information pai_emp
244: ,pay_assignment_actions paa1
245: ,pay_payroll_actions ppa1
246: ,pay_all_payrolls_f ppf
247: WHERE ptp.time_period_id = pai_emp.action_information16
248: AND pai_emp.action_context_type = 'AAP'
249: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
250: 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 301: ,pay_all_payrolls_f ppf

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

Line 325: ,pay_all_payrolls_f ppf

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

Line 353: ,pay_all_payrolls_f ppf

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

Line 384: ,pay_all_payrolls_f ppf

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

Line 417: ,pay_all_payrolls_f ppf

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

Line 465: ,pay_all_payrolls_f ppf

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

Line 508: ,pay_all_payrolls_f ppf

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