APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PAY_ACTION_INTERLOCKS

Line 391: FROM pay_action_interlocks pai_chk,

387:
388: CURSOR get_arch_asg_action_id(cp_chk_action_id in number,
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,

Line 392: pay_action_interlocks pai_arch,

388: CURSOR get_arch_asg_action_id(cp_chk_action_id in number,
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,

Line 441: FROM pay_action_interlocks pai_chk,

437:
438: CURSOR get_ca_arch_asg_action_id(cp_chk_action_id in number,
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,

Line 442: pay_action_interlocks pai_arch,

438: CURSOR get_ca_arch_asg_action_id(cp_chk_action_id in number,
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,

Line 501: FROM pay_action_interlocks pai_chk,

497:
498: CURSOR get_arch_run_asg_action_id(cp_chk_action_id in number,
499: cp_legislation_code in varchar2) is
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,

Line 502: pay_action_interlocks pai_prepay,

498: CURSOR get_arch_run_asg_action_id(cp_chk_action_id in number,
499: cp_legislation_code in varchar2) is
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,

Line 503: pay_action_interlocks pai_arch,

499: cp_legislation_code in varchar2) is
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,

Line 527: FROM pay_action_interlocks pai_chk,

523: -- ID in multi assignment payroll.
524: CURSOR get_multi_arch_asg_action_id(cp_chk_action_id in number,
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,

Line 528: pay_action_interlocks pai_arch,

524: CURSOR get_multi_arch_asg_action_id(cp_chk_action_id in number,
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,

Line 685: , pay_action_interlocks pai

681: -- added for 13029999
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