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

Line 120: pay_action_interlocks pai,

116: pay_payroll_actions appa,
117: pay_payroll_actions appa2,
118: pay_assignment_actions act,
119: pay_assignment_actions act1,
120: pay_action_interlocks pai,
121: per_all_assignments_f as1
122: WHERE ppa.payroll_action_id = p_pact_id
123: AND appa2.consolidation_set_id = p_consolidation_id
124: AND appa2.effective_date BETWEEN

Line 142: FROM pay_action_interlocks pai1,

138: AND act1.payroll_action_id = appa2.payroll_action_id
139: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
140: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
141: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
142: FROM pay_action_interlocks pai1,
143: pay_assignment_actions act2,
144: pay_payroll_actions appa3
145: WHERE pai1.locked_action_id = act.assignment_action_id
146: AND act2.assignment_action_id = pai1.locking_action_id

Line 304: FROM pay_action_interlocks pre,

300: paa.effective_date effective_date,
301: ppaa.effective_date pre_effective_date,
302: paa.date_earned date_earned,
303: paa.time_period_id time_period_id
304: FROM pay_action_interlocks pre,
305: pay_action_interlocks pay,
306: pay_payroll_actions paa,
307: pay_payroll_actions ppaa,
308: pay_assignment_actions assact,

Line 305: pay_action_interlocks pay,

301: ppaa.effective_date pre_effective_date,
302: paa.date_earned date_earned,
303: paa.time_period_id time_period_id
304: FROM pay_action_interlocks pre,
305: pay_action_interlocks pay,
306: pay_payroll_actions paa,
307: pay_payroll_actions ppaa,
308: pay_assignment_actions assact,
309: pay_assignment_actions passact