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

Line 167: (select 'x' from pay_Action_interlocks pai,

163: and paf.effective_start_date <= ppa.effective_date
164: and paf.effective_end_date >= ppa.start_date
165: and paf.assignment_type = 'E'
166: and not exists
167: (select 'x' from pay_Action_interlocks pai,
168: pay_assignment_actions paa1,
169: pay_payroll_actions ppa1
170: where pai.locked_action_id = paa.assignment_action_id
171: and paa1.assignment_action_id = pai.locking_action_id

Line 179: (select 'x' from pay_Action_interlocks pai,

175: and ppa1.report_type = 'MARK_W2C_PAPER'
176: and ppa1.report_category = 'RT'
177: and ppa1.action_status = 'C')
178: and not exists
179: (select 'x' from pay_Action_interlocks pai,
180: pay_assignment_actions paa1,
181: pay_payroll_actions ppa1
182: where pai.locked_action_id = paa.assignment_action_id
183: and paa1.assignment_action_id = pai.locking_action_id

Line 299: (select ''x'' from pay_Action_interlocks pai,

295: and paf.effective_end_date >= ppa.start_date
296: and paf.assignment_type = ''E''
297: and :payroll_action_id is not null
298: and not exists
299: (select ''x'' from pay_Action_interlocks pai,
300: pay_assignment_actions paa1,
301: pay_payroll_actions ppa1
302: where pai.locked_action_id = paa.assignment_action_id
303: and paa1.assignment_action_id = pai.locking_action_id

Line 312: (select ''x'' from pay_Action_interlocks pai,

308: and ppa1.action_type = ''X''
309: and ppa1.report_type = ''MARK_W2C_PAPER''
310: and ppa1.action_status = ''C'')
311: and not exists
312: (select ''x'' from pay_Action_interlocks pai,
313: pay_assignment_actions paa1,
314: pay_payroll_actions ppa1
315: where pai.locked_action_id = paa.assignment_action_id
316: and paa1.assignment_action_id = pai.locking_action_id

Line 373: (select 'x' from pay_Action_interlocks pai,

369: and paf.assignment_type = 'E'
370: and paf.person_id between cp_start_person_id
371: and cp_end_person_id
372: and not exists
373: (select 'x' from pay_Action_interlocks pai,
374: pay_assignment_actions paa1,
375: pay_payroll_actions ppa1
376: where pai.locked_action_id = paa.assignment_action_id
377: and paa1.assignment_action_id = pai.locking_action_id

Line 385: (select 'x' from pay_Action_interlocks pai,

381: and ppa1.report_type = 'MARK_W2C_PAPER'
382: and ppa1.report_category = 'RT'
383: and ppa1.action_status = 'C')
384: and not exists
385: (select 'x' from pay_Action_interlocks pai,
386: pay_assignment_actions paa1,
387: pay_payroll_actions ppa1
388: where pai.locked_action_id = paa.assignment_action_id
389: and paa1.assignment_action_id = pai.locking_action_id