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 137: FROM pay_action_interlocks lck, -- archive action locking prepayment

133: ,pet.element_name)
134: ,'BIK Arrearage'
135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
136: ,sum (fnd_number.canonical_to_number (prv.result_value))) numeric_value
137: FROM pay_action_interlocks lck, -- archive action locking prepayment
138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment
141: pay_action_information pai, -- archived element/input value definition

Line 142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment
141: pay_action_information pai, -- archived element/input value definition
142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
143: pay_assignment_actions paa, -- payroll run/quickpay action
144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
146: pay_input_values_f piv, -- "Pay values" of type Money

Line 1585: ,pay_action_interlocks pai_rev

1581: FROM pay_assignment_actions paa_src
1582: ,pay_assignment_actions paa_rev
1583: ,pay_assignment_actions paa_cur
1584: ,pay_payroll_actions ppa_rev
1585: ,pay_action_interlocks pai_rev
1586: WHERE paa_cur.assignment_action_id = c_assg_action_id
1587: AND paa_src.source_action_id = paa_cur.source_action_id
1588: AND paa_src.assignment_id = paa_cur.assignment_id
1589: AND pai_rev.locked_action_id = paa_src.assignment_action_id

Line 2460: pay_action_interlocks pai,

2456: pay_payroll_actions appa,
2457: pay_payroll_actions appa2,
2458: pay_assignment_actions act,
2459: pay_assignment_actions act1,
2460: pay_action_interlocks pai,
2461: per_assignments_f as1
2462: WHERE ppa.payroll_action_id = p_pact_id
2463: AND appa.consolidation_set_id = p_consolidation_id
2464: AND appa.effective_date BETWEEN

Line 2483: FROM pay_action_interlocks pai1,

2479: AND act1.payroll_action_id = appa2.payroll_action_id
2480: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2481: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2482: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2483: FROM pay_action_interlocks pai1,
2484: pay_assignment_actions act2,
2485: pay_payroll_actions appa3
2486: WHERE pai1.locked_action_id = act.assignment_action_id
2487: AND act2.assignment_action_id = pai1.locking_action_id

Line 2511: pay_action_interlocks pai,

2507: pay_payroll_actions appa,
2508: pay_payroll_actions appa2,
2509: pay_assignment_actions act,
2510: pay_assignment_actions act1,
2511: pay_action_interlocks pai,
2512: per_assignments_f as1,
2513: pay_population_ranges ppr
2514: WHERE ppa.payroll_action_id = p_pact_id
2515: AND appa.consolidation_set_id = p_consolidation_id

Line 2536: FROM pay_action_interlocks pai1,

2532: AND act1.payroll_action_id = appa2.payroll_action_id
2533: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2534: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2535: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2536: FROM pay_action_interlocks pai1,
2537: pay_assignment_actions act2,
2538: pay_payroll_actions appa3
2539: WHERE pai1.locked_action_id = act.assignment_action_id
2540: AND act2.assignment_action_id = pai1.locking_action_id

Line 2700: FROM pay_action_interlocks pre,

2696: paa.effective_date effective_date,
2697: ppaa.effective_date pre_effective_date,
2698: paa.date_earned date_earned,
2699: ptp.time_period_id time_period_id
2700: FROM pay_action_interlocks pre,
2701: pay_action_interlocks pay,
2702: pay_payroll_actions paa,
2703: pay_payroll_actions ppaa,
2704: pay_assignment_actions assact,

Line 2701: pay_action_interlocks pay,

2697: ppaa.effective_date pre_effective_date,
2698: paa.date_earned date_earned,
2699: ptp.time_period_id time_period_id
2700: FROM pay_action_interlocks pre,
2701: pay_action_interlocks pay,
2702: pay_payroll_actions paa,
2703: pay_payroll_actions ppaa,
2704: pay_assignment_actions assact,
2705: pay_assignment_actions passact,

Line 3208: pay_action_interlocks pai,

3204: pact.action_type = 'U')
3205: AND pact.action_status = 'C'
3206: AND exists (SELECT NULL
3207: FROM pay_assignment_actions paa,
3208: pay_action_interlocks pai,
3209: pay_assignment_actions paa_arc
3210: WHERE pai.locked_action_id = paa.assignment_action_id
3211: AND pai.locking_action_id = paa_arc.assignment_action_id
3212: AND paa_arc.payroll_action_id = p_pact_id