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_ASSIGNMENT_ACTIONS

Line 372: pay_assignment_actions paa,

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
376: AND ppa.business_group_id = pbg.business_group_id;

Line 380: FROM pay_assignment_actions

376: AND ppa.business_group_id = pbg.business_group_id;
377:
378: CURSOR get_action_status(cp_chk_action_id IN NUMBER) IS
379: SELECT action_status
380: FROM pay_assignment_actions
381: WHERE assignment_action_id = cp_chk_action_id ;
382:
383: -- Fetching Assignment Action ID of the Payroll / Payslip Archive
384: -- From the Assignment Action ID of Cheque Writer

Line 393: pay_assignment_actions paa_arch,

389: cp_legislation_code in varchar2) is
390: SELECT pai_arch.locking_action_id
391: FROM pay_action_interlocks pai_chk,
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,

Line 394: pay_assignment_actions paa_chk,

390: SELECT pai_arch.locking_action_id
391: FROM pay_action_interlocks pai_chk,
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

Line 443: pay_assignment_actions paa_arch,

439: cp_legislation_code in varchar2) is
440: SELECT paa_arch_ctx.assignment_action_id
441: FROM pay_action_interlocks pai_chk,
442: pay_action_interlocks pai_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,

Line 444: pay_assignment_actions paa_arch_ctx,

440: SELECT paa_arch_ctx.assignment_action_id
441: FROM pay_action_interlocks pai_chk,
442: pay_action_interlocks pai_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,

Line 445: pay_assignment_actions paa_chk,

441: FROM pay_action_interlocks pai_chk,
442: pay_action_interlocks pai_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

Line 504: pay_assignment_actions paa_arch,

500: SELECT paa_arch.assignment_action_id
501: FROM pay_action_interlocks pai_chk,
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

Line 505: pay_assignment_actions paa_prepay,

501: FROM pay_action_interlocks pai_chk,
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

Line 529: pay_assignment_actions paa_arch,

525: cp_legislation_code in varchar2) is
526: SELECT pai_arch.locking_action_id
527: FROM pay_action_interlocks pai_chk,
528: pay_action_interlocks pai_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,

Line 530: pay_assignment_actions paa_chi_pp,

526: SELECT pai_arch.locking_action_id
527: FROM pay_action_interlocks pai_chk,
528: pay_action_interlocks pai_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,

Line 531: pay_assignment_actions paa_chk,

527: FROM pay_action_interlocks pai_chk,
528: pay_action_interlocks pai_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

Line 575: FROM pay_assignment_actions

571: --
572: CURSOR get_asssignment_id(cp_chk_asg_act_id IN NUMBER)
573: IS
574: SELECT DISTINCT assignment_id
575: FROM pay_assignment_actions
576: WHERE assignment_action_id = cp_chk_asg_act_id;
577:
578: --
579: --

Line 585: ,pay_assignment_actions paa

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';
589:

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 686: , pay_assignment_actions paa

682: popm.defined_balance_id,
683: ppp.pre_payment_id
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

Line 687: , pay_assignment_actions paa_chq

683: ppp.pre_payment_id
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

Line 737: lv_action_status pay_assignment_actions.action_status%type;

733: l_account_name VARCHAR2(2000);
734: l_account_number VARCHAR2(2000);
735: l_transit_code VARCHAR2(2000);
736: l_account_typ VARCHAR2(2000);
737: lv_action_status pay_assignment_actions.action_status%type;
738:
739: ln_chq_asg_action_id NUMBER ;
740: lv_legislation_code per_business_groups.legislation_code%TYPE ;
741: lv_full_name VARCHAR2(250);

Line 1017: UPDATE pay_assignment_actions

1013:
1014: pay_core_files.write_to_magtape_lob('');
1015:
1016: BEGIN
1017: UPDATE pay_assignment_actions
1018: SET action_status = 'S'
1019: WHERE assignment_action_id = ln_chq_asg_action_id;
1020:
1021: hr_utility.trace('Update Successful..');