APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on HR_LOOKUPS

Line 398: hr_lookups hrl

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
399: WHERE pai_chk.locking_action_id = cp_chk_action_id
400:
401: --Pre-Payment Assignment Action ID is locked by both Check Writer
402: --and Payroll Archive Process (It can be locked by NACHA as well)

Line 449: hr_lookups hrl

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
450: WHERE pai_chk.locking_action_id = cp_chk_action_id
451:
452: --Pre-Payment Assignment Action ID is locked by both Check Writer
453: --and Payroll Archive Process (It can be locked by NACHA as well)

Line 508: hr_lookups hrl

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
510: AND pai_chk.locked_action_id = pai_prepay.locking_action_id
511: AND pai_prepay.locking_action_id = paa_prepay.assignment_action_id
512: AND paa_prepay.payroll_action_id = ppa_prepay.payroll_action_id

Line 535: hr_lookups hrl

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
536: WHERE pai_chk.locking_action_id = cp_chk_action_id
537: --Pre-Payment Assignment Action ID is locked by both Check Writer
538: --and Payroll Archive Process (It can be locked by NACHA as well)
539: -- AND pai_arch.locked_action_id = pai_chk.locked_action_id