APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PAY_PAYROLL_ACTIONS

Line 296: FROM pay_payroll_actions ppa,

292: -- Fetching Legislation Code
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

Line 321: pay_payroll_actions ppa_arch,

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
324: WHERE pai_chk.locking_action_id = cp_chk_action_id
325:

Line 322: pay_payroll_actions ppa_chk,

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
324: WHERE pai_chk.locking_action_id = cp_chk_action_id
325:
326: --Pre-Payment Assignment Action ID is locked by both Check Writer

Line 367: pay_payroll_actions ppa_arch,

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
371: AND pai_chk.locked_action_id = pai_prepay.locking_action_id

Line 368: pay_payroll_actions ppa_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
371: AND pai_chk.locked_action_id = pai_prepay.locking_action_id
372: AND pai_prepay.locking_action_id = paa_prepay.assignment_action_id

Line 396: FROM pay_payroll_actions ppa

392: CURSOR get_effective_date(cp_chk_asg_act_id IN NUMBER)
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';

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 497: , pay_payroll_actions ppa

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
501: and paa_chq.assignment_action_id = pai.locking_action_id

Line 498: , pay_payroll_actions ppa_chq

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
501: and paa_chq.assignment_action_id = pai.locking_action_id
502: and pai.locked_action_id = paa.assignment_action_id