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_AC_ACTION_ARCH dependencies on PAY_ACTION_INTERLOCKS

Line 1180: from pay_action_interlocks pai,

1176:
1177: cursor c_non_sep_check(cp_pymt_assignment_action_id in number
1178: ,cp_sepchk_run_type_id in number) is
1179: select paa.assignment_action_id
1180: from pay_action_interlocks pai,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa
1183: where pai.locking_action_id = cp_pymt_assignment_action_id
1184: and paa.assignment_action_id = pai.locked_action_id

Line 1584: pay_action_interlocks pai

1580: ,cp_assignment_id in number ) is
1581: select paa.assignment_action_id
1582: ,paa.run_type_id
1583: from pay_assignment_actions paa,
1584: pay_action_interlocks pai
1585: where pai.locking_action_id = cp_pymt_action_id
1586: and paa.assignment_action_id = pai.locked_action_id
1587: and paa.assignment_id = cp_assignment_id
1588: and paa.run_type_id is not null

Line 2046: FROM pay_action_interlocks pai

2042: ,cp_sepchk_run_type_id in number
2043: ,cp_element_type_id in number --#11897283
2044: ) IS
2045: SELECT paa_run.assignment_action_id
2046: FROM pay_action_interlocks pai
2047: ,pay_assignment_actions paa_run
2048: ,pay_payroll_actions ppa_run
2049: WHERE pai.locking_action_id = cp_pre_as_action_id
2050: AND pai.locked_action_id = paa_run.assignment_action_id

Line 2312: from pay_action_interlocks pai,

2308: nvl(petl.reporting_name, petl.element_name),
2309: pet.element_information10,
2310: pet.element_information12,
2311: pet.processing_priority
2312: from pay_action_interlocks pai,
2313: pay_assignment_actions paa,
2314: pay_payroll_actions ppa,
2315: pay_all_payrolls_f ppf,
2316: pay_run_results prr,