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_ACTION_INFORMATION

Line 163: ,pay_action_information pai_emp

159: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
160: SELECT distinct pai_emp.action_information15 organization
161: ,ppf.payroll_id
162: FROM per_time_periods ptp
163: ,pay_action_information pai_emp
164: ,pay_assignment_actions paa1
165: ,pay_action_interlocks lck
166: ,pay_payroll_actions ppa1
167: ,pay_all_payrolls_f ppf

Line 186: ,pay_action_information pai_emp

182: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
183: SELECT distinct pai_emp.action_information15 organization
184: ,ppf.payroll_id
185: FROM per_time_periods ptp
186: ,pay_action_information pai_emp
187: ,pay_assignment_actions paa1
188: ,pay_action_interlocks lck
189: ,pay_payroll_actions ppa1
190: ,pay_all_payrolls_f ppf

Line 219: ,pay_action_information pai_emp

215: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
216: SELECT distinct pai_emp.action_information15 organization
217: ,ppf.payroll_id
218: FROM per_time_periods ptp
219: ,pay_action_information pai_emp
220: ,pay_assignment_actions paa1
221: ,pay_action_interlocks lck
222: ,pay_payroll_actions ppa1
223: ,pay_all_payrolls_f ppf

Line 241: ,pay_action_information pai_emp

237: cursor csr_condition_three(l_effective_date date) is
238: SELECT distinct pai_emp.action_information15 organization
239: ,ppf.payroll_id
240: FROM per_time_periods ptp
241: ,pay_action_information pai_emp
242: ,pay_assignment_actions paa1
243: ,pay_action_interlocks lck
244: ,pay_payroll_actions ppa1
245: ,pay_all_payrolls_f ppf

Line 263: ,pay_action_information pai_emp

259: /* CURSOR TO GET PAYROLL IDS DISTINCT */
260: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
261: SELECT distinct ppf.payroll_id
262: FROM per_time_periods ptp
263: ,pay_action_information pai_emp
264: ,pay_assignment_actions paa1
265: ,pay_action_interlocks lck
266: ,pay_payroll_actions ppa1
267: ,pay_all_payrolls_f ppf

Line 296: ,pay_action_information pai_emp

292: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
293: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
294: SELECT distinct ppf.payroll_id
295: FROM per_time_periods ptp
296: ,pay_action_information pai_emp
297: ,pay_assignment_actions paa1
298: ,pay_action_interlocks lck
299: ,pay_payroll_actions ppa1
300: ,pay_all_payrolls_f ppf

Line 342: ,pay_action_information pai_emp

338: ,ppf.payroll_name
339: ,nvl(pai_emp1.action_information13,0) ytd_earning
340: ,nvl(pai_emp1.action_information4,0) ytd_deduction
341: FROM per_time_periods ptp
342: ,pay_action_information pai_emp
343: ,pay_action_information pai_emp1
344: ,pay_assignment_actions paa1
345: ,pay_action_interlocks lck
346: ,pay_payroll_actions ppa1

Line 343: ,pay_action_information pai_emp1

339: ,nvl(pai_emp1.action_information13,0) ytd_earning
340: ,nvl(pai_emp1.action_information4,0) ytd_deduction
341: FROM per_time_periods ptp
342: ,pay_action_information pai_emp
343: ,pay_action_information pai_emp1
344: ,pay_assignment_actions paa1
345: ,pay_action_interlocks lck
346: ,pay_payroll_actions ppa1
347: ,pay_all_payrolls_f ppf

Line 376: FROM pay_action_information pai_ele

372: ,pay_v.action_context_id arch_assact
373: ,pay_v.narrative earn_element
374: ,pay_v.numeric_value earn_value
375: ,pai_ele.action_information7
376: FROM pay_action_information pai_ele
377: ,pay_emea_paymnts_action_info_v pay_v
378: ,pay_assignment_actions paa
379: WHERE paa.assignment_action_id = l_assact_id
380: AND paa.payroll_action_id = pai_ele.action_context_id

Line 397: pay_action_information pai,

393: pay_action_interlocks lck,
394: pay_assignment_actions paa1,
395: pay_assignment_actions paa2,
396: pay_payroll_actions ppa,
397: pay_action_information pai,
398: pay_emea_payment_values_v pet
399: WHERE
400: lck.locked_action_id = paa1.assignment_action_id AND
401: paa1.source_action_id IS NULL AND

Line 422: FROM pay_action_information pai_ele

418: ,pay_v.action_context_id arch_assact
419: ,pay_v.narrative ded_element
420: ,pay_v.numeric_value ded_value
421: ,pai_ele.action_information7
422: FROM pay_action_information pai_ele
423: ,pay_emea_paymnts_action_info_v pay_v
424: ,pay_assignment_actions paa
425: WHERE paa.assignment_action_id= l_assact_id
426: AND paa.payroll_action_id = pai_ele.action_context_id

Line 443: pay_action_information pai,

439: pay_action_interlocks lck,
440: pay_assignment_actions paa1,
441: pay_assignment_actions paa2,
442: pay_payroll_actions ppa,
443: pay_action_information pai,
444: pay_emea_payment_values_v pet
445: WHERE
446: lck.locked_action_id = paa1.assignment_action_id AND
447: paa1.source_action_id IS NULL AND

Line 491: FROM pay_action_information pai_ele

487: ORDER BY status, pay_amount;
488: /* Cursor to get the sum of the Earnings for particular payroll for summary */
489: /*CURSOR csr_get_sum_earn_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
490: SELECT sum(pay_v.numeric_value)
491: FROM pay_action_information pai_ele
492: ,pay_emea_paymnts_action_info_v pay_v
493: ,pay_assignment_actions paa
494: WHERE paa.payroll_action_id = pai_ele.action_context_id
495: AND pai_ele.action_context_type = 'PA'

Line 503: ,pay_action_information pai_emp

499: AND pay_v.narrative = pai_ele.action_information4
500: AND pay_v.payment_type NOT IN ('F')
501: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
502: FROM per_time_periods ptp
503: ,pay_action_information pai_emp
504: ,pay_assignment_actions paa1
505: ,pay_action_interlocks lck
506: ,pay_payroll_actions ppa1
507: WHERE ptp.payroll_id = l_payroll_id

Line 522: FROM pay_action_information pai_ele

518: AND ptp.end_date = l_effective_date);*/
519: CURSOR csr_get_sum_earn (l_org_structure_version_id number,
520: l_organization_id number , l_payroll_id number , l_effective_date date) IS
521: SELECT sum(pay_v.numeric_value)
522: FROM pay_action_information pai_ele
523: ,pay_emea_paymnts_action_info_v pay_v
524: ,pay_assignment_actions paa
525: WHERE paa.payroll_action_id = pai_ele.action_context_id
526: AND pai_ele.action_context_type = 'PA'

Line 534: ,pay_action_information pai_emp

530: AND pay_v.narrative = pai_ele.action_information4
531: AND pay_v.payment_type NOT IN ('F')
532: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
533: FROM per_time_periods ptp
534: ,pay_action_information pai_emp
535: ,pay_assignment_actions paa1
536: ,pay_action_interlocks lck
537: ,pay_payroll_actions ppa1
538: WHERE ptp.payroll_id = l_payroll_id

Line 568: ,pay_action_information pai_ele

564: ,per_time_periods ptp
565: ,pay_assignment_actions paa1
566: ,pay_action_interlocks lck
567: ,pay_payroll_actions ppa1
568: ,pay_action_information pai_ele
569: ,pay_action_information pai_emp
570: ,pay_emea_paymnts_action_info_v pay_v
571: WHERE paa.payroll_action_id = pai_ele.action_context_id
572: AND pai_ele.action_context_type = 'PA'

Line 569: ,pay_action_information pai_emp

565: ,pay_assignment_actions paa1
566: ,pay_action_interlocks lck
567: ,pay_payroll_actions ppa1
568: ,pay_action_information pai_ele
569: ,pay_action_information pai_emp
570: ,pay_emea_paymnts_action_info_v pay_v
571: WHERE paa.payroll_action_id = pai_ele.action_context_id
572: AND pai_ele.action_context_type = 'PA'
573: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 598: ,pay_action_information pai_emp

594:
595: CURSOR csr_seoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
596: select pai_emp.action_context_id arch_assact
597: from per_time_periods ptp
598: ,pay_action_information pai_emp
599: ,pay_assignment_actions paa1
600: ,pay_action_interlocks lck
601: ,pay_payroll_actions ppa1
602: where ptp.payroll_id = l_payroll_id

Line 618: from pay_action_information pai_ele

614: and paa1.action_status = 'C'
615: and ptp.end_date = l_effective_date;
616: CURSOR csr_seoo_split_2 (l_arch_assact number) IS
617: select SUM(pay_v.numeric_value)
618: from pay_action_information pai_ele
619: ,pay_emea_paymnts_action_info_v pay_v
620: ,pay_assignment_actions paa
621: where paa.payroll_action_id = pai_ele.action_context_id
622: and pai_ele.action_context_type = 'PA'

Line 637: FROM pay_action_information pai_ele

633: --CURSOR csr_get_sum_ded_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
634: CURSOR csr_get_sum_ded (l_org_structure_version_id number,
635: l_organization_id number , l_payroll_id number , l_effective_date date) IS
636: SELECT sum(pay_v.numeric_value)
637: FROM pay_action_information pai_ele
638: ,pay_emea_paymnts_action_info_v pay_v
639: ,pay_assignment_actions paa
640: WHERE paa.payroll_action_id = pai_ele.action_context_id
641: AND pai_ele.action_context_type = 'PA'

Line 649: ,pay_action_information pai_emp

645: AND pay_v.narrative = pai_ele.action_information4
646: AND pay_v.payment_type NOT IN ('F')
647: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
648: FROM per_time_periods ptp
649: ,pay_action_information pai_emp
650: ,pay_assignment_actions paa1
651: ,pay_action_interlocks lck
652: ,pay_payroll_actions ppa1
653: WHERE ptp.payroll_id = l_payroll_id

Line 683: ,pay_action_information pai_ele

679: ,per_time_periods ptp
680: ,pay_assignment_actions paa1
681: ,pay_action_interlocks lck
682: ,pay_payroll_actions ppa1
683: ,pay_action_information pai_ele
684: ,pay_action_information pai_emp
685: ,pay_emea_paymnts_action_info_v pay_v
686: WHERE paa.payroll_action_id = pai_ele.action_context_id
687: AND pai_ele.action_context_type = 'PA'

Line 684: ,pay_action_information pai_emp

680: ,pay_assignment_actions paa1
681: ,pay_action_interlocks lck
682: ,pay_payroll_actions ppa1
683: ,pay_action_information pai_ele
684: ,pay_action_information pai_emp
685: ,pay_emea_paymnts_action_info_v pay_v
686: WHERE paa.payroll_action_id = pai_ele.action_context_id
687: AND pai_ele.action_context_type = 'PA'
688: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 713: ,pay_action_information pai_emp

709:
710: CURSOR csr_sdoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
711: select pai_emp.action_context_id arch_assact
712: from per_time_periods ptp
713: ,pay_action_information pai_emp
714: ,pay_assignment_actions paa1
715: ,pay_action_interlocks lck
716: ,pay_payroll_actions ppa1
717: where ptp.payroll_id = l_payroll_id

Line 733: from pay_action_information pai_ele

729: and paa1.action_status = 'C'
730: and ptp.end_date = l_effective_date;
731: CURSOR csr_sdoo_split_2 (l_arch_assact number) IS
732: select SUM(pay_v.numeric_value)
733: from pay_action_information pai_ele
734: ,pay_emea_paymnts_action_info_v pay_v
735: ,pay_assignment_actions paa
736: where paa.payroll_action_id = pai_ele.action_context_id
737: and pai_ele.action_context_type = 'PA'