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_ACTION_INTERLOCKS

Line 316: FROM pay_action_interlocks pai_chk,

312:
313: CURSOR get_arch_asg_action_id(cp_chk_action_id in number,
314: cp_legislation_code in varchar2) is
315: SELECT pai_arch.locking_action_id
316: FROM pay_action_interlocks pai_chk,
317: pay_action_interlocks pai_arch,
318: pay_assignment_actions paa_arch,
319: pay_assignment_actions paa_chk,
320: pay_pre_payments ppp,

Line 317: pay_action_interlocks pai_arch,

313: CURSOR get_arch_asg_action_id(cp_chk_action_id in number,
314: cp_legislation_code in varchar2) is
315: SELECT pai_arch.locking_action_id
316: FROM pay_action_interlocks pai_chk,
317: pay_action_interlocks pai_arch,
318: pay_assignment_actions paa_arch,
319: pay_assignment_actions paa_chk,
320: pay_pre_payments ppp,
321: pay_payroll_actions ppa_arch,

Line 362: FROM pay_action_interlocks pai_chk,

358:
359: CURSOR get_arch_run_asg_action_id(cp_chk_action_id in number,
360: cp_legislation_code in varchar2) is
361: SELECT paa_arch.assignment_action_id
362: FROM pay_action_interlocks pai_chk,
363: pay_action_interlocks pai_prepay,
364: pay_action_interlocks pai_arch,
365: pay_assignment_actions paa_arch,
366: pay_assignment_actions paa_prepay,

Line 363: pay_action_interlocks pai_prepay,

359: CURSOR get_arch_run_asg_action_id(cp_chk_action_id in number,
360: cp_legislation_code in varchar2) is
361: SELECT paa_arch.assignment_action_id
362: FROM pay_action_interlocks pai_chk,
363: pay_action_interlocks pai_prepay,
364: pay_action_interlocks pai_arch,
365: pay_assignment_actions paa_arch,
366: pay_assignment_actions paa_prepay,
367: pay_payroll_actions ppa_arch,

Line 364: pay_action_interlocks pai_arch,

360: cp_legislation_code in varchar2) is
361: SELECT paa_arch.assignment_action_id
362: FROM pay_action_interlocks pai_chk,
363: pay_action_interlocks pai_prepay,
364: pay_action_interlocks pai_arch,
365: pay_assignment_actions paa_arch,
366: pay_assignment_actions paa_prepay,
367: pay_payroll_actions ppa_arch,
368: pay_payroll_actions ppa_prepay,

Line 494: , pay_action_interlocks pai

490: SELECT ppp.payees_org_payment_method_id,
491: ppp.personal_payment_method_id,
492: ppp.org_payment_method_id
493: FROM pay_pre_payments ppp
494: , pay_action_interlocks pai
495: , pay_assignment_actions paa
496: , pay_assignment_actions paa_chq
497: , pay_payroll_actions ppa
498: , pay_payroll_actions ppa_chq