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

Line 150: pay_action_interlocks pai_pre,

146: from per_assignments_f asg,
147: pay_payroll_actions pp1,
148: pay_assignment_actions paa,
149: pay_payroll_actions ppa,
150: pay_action_interlocks pai_pre,
151: pay_assignment_actions paa_run,
152: pay_payroll_actions ppa_run,
153: pay_all_payrolls_f pap
154: where pp1.payroll_action_id = pactid

Line 174: from pay_action_interlocks alock,

170: and paa_run.payroll_action_id = ppa_run.payroll_action_id
171: and paa_run.source_action_id IS NULL
172: and ppa_run.action_type in ('Q','R')
173: and not exists (select /*+ INDEX(payact PAY_PAYROLL_ACTIONS_PK) */ null
174: from pay_action_interlocks alock,
175: pay_assignment_actions assact,
176: pay_payroll_actions payact
177: where alock.locked_action_id = paa.assignment_action_id
178: and assact.assignment_action_id = alock.locking_action_id

Line 280: pay_action_interlocks alock

276: -- bug fix 5371061, added ordered join to remove merge join cartesian.
277: and not exists (select /*+ ORDERED */ null
278: from pay_payroll_actions payact,
279: pay_assignment_actions assact,
280: pay_action_interlocks alock
281: where alock.locked_action_id = paa.assignment_action_id
282: and assact.assignment_action_id = alock.locking_action_id
283: and assact.payroll_action_id = payact.payroll_action_id
284: and payact.action_type = 'X'

Line 344: pay_action_interlocks pai_p30,

340: paa_p30.assignment_id assignment_id,
341: pact_er.action_information5 employer_paye_number
342: FROM pay_payroll_actions ppa_p30,
343: pay_assignment_actions paa_p30,
344: pay_action_interlocks pai_p30,
345: pay_assignment_actions paa_arc,
346: pay_action_interlocks pai_arc,
347: pay_assignment_actions paa_prepay,
348: pay_action_interlocks pai_prepay,

Line 346: pay_action_interlocks pai_arc,

342: FROM pay_payroll_actions ppa_p30,
343: pay_assignment_actions paa_p30,
344: pay_action_interlocks pai_p30,
345: pay_assignment_actions paa_arc,
346: pay_action_interlocks pai_arc,
347: pay_assignment_actions paa_prepay,
348: pay_action_interlocks pai_prepay,
349: pay_action_information pact_er,
350: pay_action_information pact_ee

Line 348: pay_action_interlocks pai_prepay,

344: pay_action_interlocks pai_p30,
345: pay_assignment_actions paa_arc,
346: pay_action_interlocks pai_arc,
347: pay_assignment_actions paa_prepay,
348: pay_action_interlocks pai_prepay,
349: pay_action_information pact_er,
350: pay_action_information pact_ee
351: -- pay_pre_payments ppp -- Bug Fix 3725003
352: WHERE ppa_p30.payroll_action_id = c_p30_data_lock_process

Line 376: pay_action_interlocks pai_p30,

372: CURSOR cur_get_archive_pactid(
373: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
374: SELECT max(ppa_arc.payroll_action_id) archive_pactid
375: FROM pay_assignment_actions paa_p30,
376: pay_action_interlocks pai_p30,
377: pay_assignment_actions paa_arc,
378: pay_payroll_actions ppa_arc
379: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
380: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 388: pay_action_interlocks pai_p30,

384: CURSOR cur_p30_start_date(
385: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
386: SELECT to_char(MIN(ppa_arc.start_date),'DD/MM/RRRR') start_date
387: FROM pay_assignment_actions paa_p30,
388: pay_action_interlocks pai_p30,
389: pay_assignment_actions paa_arc,
390: pay_payroll_actions ppa_arc
391: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
392: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 421: pay_action_interlocks pai_p30,

417: vp_action_context_id number,
418: vp_effective_date date)IS -- SR 17318286.6 rbhardwa
419: SELECT pact_ytdbal.action_information4 Balance_Value
420: FROM pay_assignment_actions paa_p30,
421: pay_action_interlocks pai_p30,
422: pay_assignment_actions paa_arc,
423: pay_action_information pact_ytdbal,
424: pay_defined_balances pdb_ytdbal,
425: pay_balance_types pbt_ytdbal,

Line 495: pay_action_interlocks pai_p30,

491: CURSOR get_action_context (vp_Payroll_Action_Id Pay_Payroll_Actions.Payroll_Action_ID%TYPE,
492: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE) IS
493: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa_run.action_sequence,15,'0')||pact_ytdbal.ACTION_CONTEXT_ID),16))
494: FROM pay_assignment_actions paa_p30,
495: pay_action_interlocks pai_p30,
496: pay_assignment_actions paa_arc,
497: pay_action_information pact_ytdbal,
498: pay_action_interlocks pai_arc,
499: pay_assignment_actions paa_run,

Line 498: pay_action_interlocks pai_arc,

494: FROM pay_assignment_actions paa_p30,
495: pay_action_interlocks pai_p30,
496: pay_assignment_actions paa_arc,
497: pay_action_information pact_ytdbal,
498: pay_action_interlocks pai_arc,
499: pay_assignment_actions paa_run,
500: pay_payroll_actions ppa_run
501: -- ,pay_pre_payments ppp --Bug Fix 4049831 Added join with pay_pre_payments table
502: WHERE paa_p30.payroll_action_id = vp_Payroll_Action_Id