APPS.PAY_CA_RL1_AMEND_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 482: FROM pay_action_interlocks pail,

478: and paf1.effective_start_date <= ppa1.effective_date)
479:
480: AND not exists
481: ( SELECT pail.locked_action_id
482: FROM pay_action_interlocks pail,
483: pay_payroll_actions pact,
484: pay_assignment_actions passt
485: WHERE pact.report_type = 'RL1_AMEND_MAG'
486: AND pact.payroll_action_id = passt.payroll_action_id

Line 492: FROM pay_action_interlocks pail,

488: AND pail.locked_action_id = paa.assignment_action_id)
489:
490: AND not exists
491: ( SELECT pail.locked_action_id
492: FROM pay_action_interlocks pail,
493: pay_payroll_actions pact,
494: pay_assignment_actions passt
495: WHERE pact.report_type = 'RL1_XML_MAG'
496: AND pact.payroll_action_id = passt.payroll_action_id

Line 502: FROM pay_action_interlocks pail,

498: AND pail.locked_action_id = paa.assignment_action_id)
499:
500: AND not exists
501: ( SELECT pail.locked_action_id
502: FROM pay_action_interlocks pail,
503: pay_payroll_actions pact,
504: pay_assignment_actions passt
505: WHERE pact.report_type = 'CAEOY_RL1_AMEND_PP'
506: AND pact.payroll_action_id = passt.payroll_action_id

Line 546: FROM pay_action_interlocks pail,

542: and paf.effective_start_date <= cp_effective_date
543: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
544: AND not exists
545: ( SELECT pail.locked_action_id
546: FROM pay_action_interlocks pail,
547: pay_payroll_actions pact,
548: pay_assignment_actions passt
549: WHERE pact.report_type = 'RL1_AMEND_MAG'
550: AND pact.payroll_action_id = passt.payroll_action_id

Line 1421: pay_action_interlocks pai,

1417: ff_archive_items fai,
1418: ff_database_items fdi,
1419: per_all_people_f ppf,
1420: per_all_assignments_f paf,
1421: pay_action_interlocks pai,
1422: pay_assignment_actions paa,
1423: pay_payroll_actions ppa,
1424: pay_assignment_actions paa_arch
1425: WHERE