APPS.PAY_AC_ACTION_ARCH dependencies on PAY_ACTION_INTERLOCKS

Line 909: from pay_action_interlocks pai,

905:
906: cursor c_non_sep_check(cp_pymt_assignment_action_id in number
907: ,cp_sepchk_run_type_id in number) is
908: select paa.assignment_action_id
909: from pay_action_interlocks pai,
910: pay_assignment_actions paa,
911: pay_payroll_actions ppa
912: where pai.locking_action_id = cp_pymt_assignment_action_id
913: and paa.assignment_action_id = pai.locked_action_id

Line 1276: pay_action_interlocks pai

1272: ,cp_assignment_id in number ) is
1273: select paa.assignment_action_id
1274: ,paa.run_type_id
1275: from pay_assignment_actions paa,
1276: pay_action_interlocks pai
1277: where pai.locking_action_id = cp_pymt_action_id
1278: and paa.assignment_action_id = pai.locked_action_id
1279: and paa.assignment_id = cp_assignment_id
1280: and paa.run_type_id is not null

Line 1730: FROM pay_action_interlocks pai, pay_assignment_actions paa,

1726: CURSOR get_run_action_id(cp_pre_as_action_id in number,
1727: cp_assignment_id in number
1728: ) IS
1729: SELECT paa.assignment_action_id
1730: FROM pay_action_interlocks pai, pay_assignment_actions paa,
1731: pay_payroll_actions ppa
1732: WHERE pai.locking_action_id =cp_pre_as_action_id
1733: AND pai.locked_action_id = paa.assignment_action_id
1734: AND paa.assignment_id = cp_assignment_id

Line 1955: from pay_action_interlocks pai,

1951: nvl(petl.reporting_name, petl.element_name),
1952: pet.element_information10,
1953: pet.element_information12,
1954: pet.processing_priority
1955: from pay_action_interlocks pai,
1956: pay_assignment_actions paa,
1957: pay_payroll_actions ppa,
1958: pay_all_payrolls_f ppf,
1959: pay_run_results prr,