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

Line 1364: ,pay_action_interlocks pai_rev

1360: FROM pay_assignment_actions paa_src
1361: ,pay_assignment_actions paa_rev
1362: ,pay_assignment_actions paa_cur
1363: ,pay_payroll_actions ppa_rev
1364: ,pay_action_interlocks pai_rev
1365: WHERE paa_cur.assignment_action_id = c_assg_action_id
1366: AND paa_src.source_action_id = paa_cur.source_action_id
1367: AND paa_src.assignment_id = paa_cur.assignment_id
1368: AND pai_rev.locked_action_id = paa_src.assignment_action_id

Line 2163: pay_action_interlocks pai,

2159: pay_payroll_actions appa,
2160: pay_payroll_actions appa2,
2161: pay_assignment_actions act,
2162: pay_assignment_actions act1,
2163: pay_action_interlocks pai,
2164: per_assignments_f as1
2165: WHERE ppa.payroll_action_id = p_pact_id
2166: AND appa.consolidation_set_id = p_consolidation_id
2167: AND appa.effective_date BETWEEN

Line 2186: FROM pay_action_interlocks pai1,

2182: AND act1.payroll_action_id = appa2.payroll_action_id
2183: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2184: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2185: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2186: FROM pay_action_interlocks pai1,
2187: pay_assignment_actions act2,
2188: pay_payroll_actions appa3
2189: WHERE pai1.locked_action_id = act.assignment_action_id
2190: AND act2.assignment_action_id = pai1.locking_action_id

Line 2214: pay_action_interlocks pai,

2210: pay_payroll_actions appa,
2211: pay_payroll_actions appa2,
2212: pay_assignment_actions act,
2213: pay_assignment_actions act1,
2214: pay_action_interlocks pai,
2215: per_assignments_f as1,
2216: pay_population_ranges ppr
2217: WHERE ppa.payroll_action_id = p_pact_id
2218: AND appa.consolidation_set_id = p_consolidation_id

Line 2239: FROM pay_action_interlocks pai1,

2235: AND act1.payroll_action_id = appa2.payroll_action_id
2236: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2237: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2238: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2239: FROM pay_action_interlocks pai1,
2240: pay_assignment_actions act2,
2241: pay_payroll_actions appa3
2242: WHERE pai1.locked_action_id = act.assignment_action_id
2243: AND act2.assignment_action_id = pai1.locking_action_id

Line 2403: FROM pay_action_interlocks pre,

2399: paa.effective_date effective_date,
2400: ppaa.effective_date pre_effective_date,
2401: paa.date_earned date_earned,
2402: ptp.time_period_id time_period_id
2403: FROM pay_action_interlocks pre,
2404: pay_action_interlocks pay,
2405: pay_payroll_actions paa,
2406: pay_payroll_actions ppaa,
2407: pay_assignment_actions assact,

Line 2404: pay_action_interlocks pay,

2400: ppaa.effective_date pre_effective_date,
2401: paa.date_earned date_earned,
2402: ptp.time_period_id time_period_id
2403: FROM pay_action_interlocks pre,
2404: pay_action_interlocks pay,
2405: pay_payroll_actions paa,
2406: pay_payroll_actions ppaa,
2407: pay_assignment_actions assact,
2408: pay_assignment_actions passact,

Line 2893: pay_action_interlocks pai,

2889: pact.action_type = 'U')
2890: AND pact.action_status = 'C'
2891: AND exists (SELECT NULL
2892: FROM pay_assignment_actions paa,
2893: pay_action_interlocks pai,
2894: pay_assignment_actions paa_arc
2895: WHERE pai.locked_action_id = paa.assignment_action_id
2896: AND pai.locking_action_id = paa_arc.assignment_action_id
2897: AND paa_arc.payroll_action_id = p_pact_id