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

293: --
294: CURSOR get_legislation_code(cp_chk_action_id in number) is
295: SELECT pbg.legislation_code
296: FROM pay_payroll_actions ppa,
297: pay_assignment_actions paa,
298: per_business_groups pbg
299: WHERE paa.assignment_action_id = cp_chk_action_id
300: AND paa.payroll_action_id = ppa.payroll_action_id
301: AND ppa.business_group_id = pbg.business_group_id;

Line 305: FROM pay_assignment_actions

301: AND ppa.business_group_id = pbg.business_group_id;
302:
303: CURSOR get_action_status(cp_chk_action_id IN NUMBER) IS
304: SELECT action_status
305: FROM pay_assignment_actions
306: WHERE assignment_action_id = cp_chk_action_id ;
307:
308: -- Fetching Assignment Action ID of the Payroll / Payslip Archive
309: -- From the Assignment Action ID of Cheque Writer

Line 318: pay_assignment_actions paa_arch,

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,
322: pay_payroll_actions ppa_chk,

Line 319: pay_assignment_actions paa_chk,

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,
322: pay_payroll_actions ppa_chk,
323: hr_lookups hrl

Line 365: pay_assignment_actions paa_arch,

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,
369: hr_lookups hrl

Line 366: pay_assignment_actions paa_prepay,

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,
369: hr_lookups hrl
370: WHERE pai_chk.locking_action_id = cp_chk_action_id

Line 387: FROM pay_assignment_actions

383: --
384: CURSOR get_asssignment_id(cp_chk_asg_act_id IN NUMBER)
385: IS
386: SELECT DISTINCT assignment_id
387: FROM pay_assignment_actions
388: WHERE assignment_action_id = cp_chk_asg_act_id;
389:
390: --
391: --

Line 397: ,pay_assignment_actions paa

393: IS
394: SELECT ppa.effective_date
395: ,ppa.payroll_action_id
396: FROM pay_payroll_actions ppa
397: ,pay_assignment_actions paa
398: WHERE paa.assignment_action_id = cp_chk_asg_act_id
399: AND paa.payroll_action_id = ppa.payroll_action_id
400: AND ppa.action_type = 'H';
401:

Line 449: FROM pay_assignment_actions paa,pay_payroll_actions ppa

445: SELECT nvl(paa.serial_number,'-9999')
446: ,substr(fnd_date.date_to_canonical(ppa.effective_date),1,10)
447: ,substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10)
448: ,ppa.payroll_action_id
449: FROM pay_assignment_actions paa,pay_payroll_actions ppa
450: WHERE paa.assignment_action_id = cp_chk_asg_act_id
451: AND paa.payroll_action_id = ppa.payroll_action_id ;
452:
453: --

Line 495: , pay_assignment_actions paa

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
499: , pay_org_payment_methods_f popm

Line 496: , pay_assignment_actions paa_chq

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
499: , pay_org_payment_methods_f popm
500: WHERE paa_chq.assignment_action_id = cp_chk_action_id

Line 546: lv_action_status pay_assignment_actions.action_status%type;

542: l_account_name VARCHAR2(2000);
543: l_account_number VARCHAR2(2000);
544: l_transit_code VARCHAR2(2000);
545: l_account_typ VARCHAR2(2000);
546: lv_action_status pay_assignment_actions.action_status%type;
547:
548: ln_chq_asg_action_id NUMBER ;
549: lv_legislation_code per_business_groups.legislation_code%TYPE ;
550: lv_full_name VARCHAR2(250);

Line 739: UPDATE pay_assignment_actions

735:
736: pay_core_files.write_to_magtape_lob('');
737:
738: BEGIN
739: UPDATE pay_assignment_actions
740: SET action_status = 'S'
741: WHERE assignment_action_id = ln_chq_asg_action_id;
742:
743: hr_utility.trace('Update Successful..');