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 165: (select 'x' from pay_Action_interlocks pai,

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

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

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

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

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

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

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

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

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

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

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