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

Line 413: pay_action_interlocks lck

409: AND paa_arch.tax_unit_id = g_mag_gre_id
410: /*AND NOT EXISTS (SELECT 'X'
411: FROM pay_payroll_actions ppa_sua,
412: pay_assignment_actions paa_sua,
413: pay_action_interlocks lck
414: WHERE lck.locked_action_id = pai.action_context_id
415: AND lck.locking_action_id =
416: paa_sua.assignment_action_id
417: AND paa_sua.payroll_action_id =

Line 474: pay_action_interlocks lck

470: AND paa_arch.tax_unit_id = g_mag_gre_id
471: /*AND NOT EXISTS (SELECT 'X'
472: FROM pay_payroll_actions ppa_sua,
473: pay_assignment_actions paa_sua,
474: pay_action_interlocks lck
475: WHERE lck.locked_action_id = pai.action_context_id
476: AND lck.locking_action_id =
477: paa_sua.assignment_action_id
478: AND paa_sua.payroll_action_id =

Line 677: pay_action_interlocks lck

673: nvl(pai.action_information21, 'N') -- Do not report flag
674: FROM pay_action_information pai,
675: pay_assignment_actions paa_arch,
676: per_all_assignments_f paf,
677: pay_action_interlocks lck
678: WHERE pai.action_context_id = paa_arch.assignment_action_id
679: AND paf.assignment_id = paa_arch.assignment_id
680: AND pai.effective_date BETWEEN paf.effective_start_date AND
681: paf.effective_end_date

Line 703: pay_action_interlocks lck

699: pai.action_information2 -- transaction date
700: FROM pay_action_information pai,
701: pay_assignment_actions paa_arch,
702: per_all_assignments_f paf,
703: pay_action_interlocks lck
704: WHERE pai.action_context_id = paa_arch.assignment_action_id
705: AND paf.assignment_id = paa_arch.assignment_id
706: --Bug 7185703
707: AND fnd_date.canonical_to_date (pai.action_information2) >= fnd_date.canonical_to_date(cp_imp_date)

Line 745: pay_action_interlocks lck

741: pay_payroll_actions ppa_mag,
742: pay_assignment_actions paa_mag_prev,
743: pay_payroll_actions ppa_mag_prev,
744: pay_action_information pai,
745: pay_action_interlocks lck
746: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id
747: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id
748: AND pay_mx_utility.get_legi_param_val ('GRE',
749: ppa_mag.payroll_action_id) =

Line 823: pay_action_interlocks lck,

819: SELECT fnd_number.canonical_to_number(pai.action_information8)
820: FROM pay_payroll_actions ppa_sua,
821: pay_assignment_actions paa_sua,
822: pay_assignment_actions paa_arch,
823: pay_action_interlocks lck,
824: pay_action_information pai
825: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
826: AND paa_sua.assignment_action_id = lck.locking_action_id
827: AND lck.locked_action_id = paa_arch.assignment_action_id

Line 1205: pay_action_interlocks lck

1201: CURSOR get_arch_pact_id (cp_chunk NUMBER) IS
1202: SELECT DISTINCT paa_arch.payroll_action_id
1203: FROM pay_assignment_actions paa_arch,
1204: pay_assignment_actions paa_mag,
1205: pay_action_interlocks lck
1206: WHERE paa_arch.assignment_action_id = lck.locked_action_id
1207: AND lck.locking_action_id = paa_mag.assignment_action_id
1208: AND paa_mag.chunk_number >= cp_chunk
1209: AND paa_mag.payroll_action_id =