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: ,pay_action_information pai --12943478

Line 180: from pay_action_interlocks alock,

176: and pai.action_information_category = 'IE EMPLOYEE DETAILS'
177: and pai.action_context_type='AAP'
178: --12943478
179: and not exists (select /*+ INDEX(payact PAY_PAYROLL_ACTIONS_PK) */ null
180: from pay_action_interlocks alock,
181: pay_assignment_actions assact,
182: pay_payroll_actions payact
183: where alock.locked_action_id = paa.assignment_action_id
184: and assact.assignment_action_id = alock.locking_action_id

Line 286: pay_action_interlocks alock

282: -- bug fix 5371061, added ordered join to remove merge join cartesian.
283: and not exists (select /*+ ORDERED */ null
284: from pay_payroll_actions payact,
285: pay_assignment_actions assact,
286: pay_action_interlocks alock
287: where alock.locked_action_id = paa.assignment_action_id
288: and assact.assignment_action_id = alock.locking_action_id
289: and assact.payroll_action_id = payact.payroll_action_id
290: and payact.action_type = 'X'

Line 350: pay_action_interlocks pai_p30,

346: paa_p30.assignment_id assignment_id,
347: pact_er.action_information5 employer_paye_number
348: FROM pay_payroll_actions ppa_p30,
349: pay_assignment_actions paa_p30,
350: pay_action_interlocks pai_p30,
351: pay_assignment_actions paa_arc,
352: pay_action_interlocks pai_arc,
353: pay_assignment_actions paa_prepay,
354: pay_action_interlocks pai_prepay,

Line 352: pay_action_interlocks pai_arc,

348: FROM pay_payroll_actions ppa_p30,
349: pay_assignment_actions paa_p30,
350: pay_action_interlocks pai_p30,
351: pay_assignment_actions paa_arc,
352: pay_action_interlocks pai_arc,
353: pay_assignment_actions paa_prepay,
354: pay_action_interlocks pai_prepay,
355: pay_action_information pact_er,
356: pay_action_information pact_ee

Line 354: pay_action_interlocks pai_prepay,

350: pay_action_interlocks pai_p30,
351: pay_assignment_actions paa_arc,
352: pay_action_interlocks pai_arc,
353: pay_assignment_actions paa_prepay,
354: pay_action_interlocks pai_prepay,
355: pay_action_information pact_er,
356: pay_action_information pact_ee
357: -- pay_pre_payments ppp -- Bug Fix 3725003
358: WHERE ppa_p30.payroll_action_id = c_p30_data_lock_process

Line 382: pay_action_interlocks pai_p30,

378: CURSOR cur_get_archive_pactid(
379: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
380: SELECT max(ppa_arc.payroll_action_id) archive_pactid
381: FROM pay_assignment_actions paa_p30,
382: pay_action_interlocks pai_p30,
383: pay_assignment_actions paa_arc,
384: pay_payroll_actions ppa_arc
385: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
386: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 394: pay_action_interlocks pai_p30,

390: CURSOR cur_p30_start_date(
391: c_p30_data_lock_process pay_payroll_actions.payroll_action_id%TYPE) IS
392: SELECT to_char(MIN(ppa_arc.start_date),'DD/MM/RRRR') start_date
393: FROM pay_assignment_actions paa_p30,
394: pay_action_interlocks pai_p30,
395: pay_assignment_actions paa_arc,
396: pay_payroll_actions ppa_arc
397: WHERE paa_p30.payroll_Action_id = c_p30_data_lock_process
398: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 427: pay_action_interlocks pai_p30,

423: vp_action_context_id number,
424: vp_effective_date date)IS -- SR 17318286.6 rbhardwa
425: SELECT pact_ytdbal.action_information4 Balance_Value
426: FROM pay_assignment_actions paa_p30,
427: pay_action_interlocks pai_p30,
428: pay_assignment_actions paa_arc,
429: pay_action_information pact_ytdbal,
430: pay_defined_balances pdb_ytdbal,
431: pay_balance_types pbt_ytdbal,

Line 501: pay_action_interlocks pai_p30,

497: CURSOR get_action_context (vp_Payroll_Action_Id Pay_Payroll_Actions.Payroll_Action_ID%TYPE,
498: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE) IS
499: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa_run.action_sequence,15,'0')||pact_ytdbal.ACTION_CONTEXT_ID),16))
500: FROM pay_assignment_actions paa_p30,
501: pay_action_interlocks pai_p30,
502: pay_assignment_actions paa_arc,
503: pay_action_information pact_ytdbal,
504: pay_action_interlocks pai_arc,
505: pay_assignment_actions paa_run,

Line 504: pay_action_interlocks pai_arc,

500: FROM pay_assignment_actions paa_p30,
501: pay_action_interlocks pai_p30,
502: pay_assignment_actions paa_arc,
503: pay_action_information pact_ytdbal,
504: pay_action_interlocks pai_arc,
505: pay_assignment_actions paa_run,
506: pay_payroll_actions ppa_run
507: -- ,pay_pre_payments ppp --Bug Fix 4049831 Added join with pay_pre_payments table
508: WHERE paa_p30.payroll_action_id = vp_Payroll_Action_Id