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_ARCHIVE_CHEQUEWRITER dependencies on PAY_PAYROLL_ACTIONS

Line 371: FROM pay_payroll_actions ppa,

367: -- Fetching Legislation Code
368: --
369: CURSOR get_legislation_code(cp_chk_action_id in number) is
370: SELECT pbg.legislation_code
371: FROM pay_payroll_actions ppa,
372: pay_assignment_actions paa,
373: per_business_groups pbg
374: WHERE paa.assignment_action_id = cp_chk_action_id
375: AND paa.payroll_action_id = ppa.payroll_action_id

Line 396: pay_payroll_actions ppa_arch,

392: pay_action_interlocks pai_arch,
393: pay_assignment_actions paa_arch,
394: pay_assignment_actions paa_chk,
395: pay_pre_payments ppp,
396: pay_payroll_actions ppa_arch,
397: pay_payroll_actions ppa_chk,
398: hr_lookups hrl
399: WHERE pai_chk.locking_action_id = cp_chk_action_id
400:

Line 397: pay_payroll_actions ppa_chk,

393: pay_assignment_actions paa_arch,
394: pay_assignment_actions paa_chk,
395: pay_pre_payments ppp,
396: pay_payroll_actions ppa_arch,
397: pay_payroll_actions ppa_chk,
398: hr_lookups hrl
399: WHERE pai_chk.locking_action_id = cp_chk_action_id
400:
401: --Pre-Payment Assignment Action ID is locked by both Check Writer

Line 447: pay_payroll_actions ppa_arch,

443: pay_assignment_actions paa_arch,
444: pay_assignment_actions paa_arch_ctx,
445: pay_assignment_actions paa_chk,
446: pay_pre_payments ppp,
447: pay_payroll_actions ppa_arch,
448: pay_payroll_actions ppa_chk,
449: hr_lookups hrl
450: WHERE pai_chk.locking_action_id = cp_chk_action_id
451:

Line 448: pay_payroll_actions ppa_chk,

444: pay_assignment_actions paa_arch_ctx,
445: pay_assignment_actions paa_chk,
446: pay_pre_payments ppp,
447: pay_payroll_actions ppa_arch,
448: pay_payroll_actions ppa_chk,
449: hr_lookups hrl
450: WHERE pai_chk.locking_action_id = cp_chk_action_id
451:
452: --Pre-Payment Assignment Action ID is locked by both Check Writer

Line 506: pay_payroll_actions ppa_arch,

502: pay_action_interlocks pai_prepay,
503: pay_action_interlocks pai_arch,
504: pay_assignment_actions paa_arch,
505: pay_assignment_actions paa_prepay,
506: pay_payroll_actions ppa_arch,
507: pay_payroll_actions ppa_prepay,
508: hr_lookups hrl
509: WHERE pai_chk.locking_action_id = cp_chk_action_id
510: AND pai_chk.locked_action_id = pai_prepay.locking_action_id

Line 507: pay_payroll_actions ppa_prepay,

503: pay_action_interlocks pai_arch,
504: pay_assignment_actions paa_arch,
505: pay_assignment_actions paa_prepay,
506: pay_payroll_actions ppa_arch,
507: pay_payroll_actions ppa_prepay,
508: hr_lookups hrl
509: WHERE pai_chk.locking_action_id = cp_chk_action_id
510: AND pai_chk.locked_action_id = pai_prepay.locking_action_id
511: AND pai_prepay.locking_action_id = paa_prepay.assignment_action_id

Line 533: pay_payroll_actions ppa_arch,

529: pay_assignment_actions paa_arch,
530: pay_assignment_actions paa_chi_pp,
531: pay_assignment_actions paa_chk,
532: pay_pre_payments ppp,
533: pay_payroll_actions ppa_arch,
534: pay_payroll_actions ppa_chk,
535: hr_lookups hrl
536: WHERE pai_chk.locking_action_id = cp_chk_action_id
537: --Pre-Payment Assignment Action ID is locked by both Check Writer

Line 534: pay_payroll_actions ppa_chk,

530: pay_assignment_actions paa_chi_pp,
531: pay_assignment_actions paa_chk,
532: pay_pre_payments ppp,
533: pay_payroll_actions ppa_arch,
534: pay_payroll_actions ppa_chk,
535: hr_lookups hrl
536: WHERE pai_chk.locking_action_id = cp_chk_action_id
537: --Pre-Payment Assignment Action ID is locked by both Check Writer
538: --and Payroll Archive Process (It can be locked by NACHA as well)

Line 584: FROM pay_payroll_actions ppa

580: CURSOR get_effective_date(cp_chk_asg_act_id IN NUMBER)
581: IS
582: SELECT ppa.effective_date
583: ,ppa.payroll_action_id
584: FROM pay_payroll_actions ppa
585: ,pay_assignment_actions paa
586: WHERE paa.assignment_action_id = cp_chk_asg_act_id
587: AND paa.payroll_action_id = ppa.payroll_action_id
588: AND ppa.action_type = 'H';

Line 637: FROM pay_assignment_actions paa,pay_payroll_actions ppa

633: SELECT nvl(paa.serial_number,'-9999')
634: ,substr(fnd_date.date_to_canonical(ppa.effective_date),1,10)
635: ,substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10)
636: ,ppa.payroll_action_id
637: FROM pay_assignment_actions paa,pay_payroll_actions ppa
638: WHERE paa.assignment_action_id = cp_chk_asg_act_id
639: AND paa.payroll_action_id = ppa.payroll_action_id ;
640:
641: --

Line 688: , pay_payroll_actions ppa

684: FROM pay_pre_payments ppp
685: , pay_action_interlocks pai
686: , pay_assignment_actions paa
687: , pay_assignment_actions paa_chq
688: , pay_payroll_actions ppa
689: , pay_payroll_actions ppa_chq
690: , pay_org_payment_methods_f popm
691: WHERE paa_chq.assignment_action_id = cp_chk_action_id
692: and paa_chq.assignment_action_id = pai.locking_action_id

Line 689: , pay_payroll_actions ppa_chq

685: , pay_action_interlocks pai
686: , pay_assignment_actions paa
687: , pay_assignment_actions paa_chq
688: , pay_payroll_actions ppa
689: , pay_payroll_actions ppa_chq
690: , pay_org_payment_methods_f popm
691: WHERE paa_chq.assignment_action_id = cp_chk_action_id
692: and paa_chq.assignment_action_id = pai.locking_action_id
693: and pai.locked_action_id = paa.assignment_action_id