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_ASSIGNMENT_ACTIONS

Line 148: pay_assignment_actions paa,

144: ppa.date_earned,
145: paa_run.tax_unit_id
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,

Line 151: pay_assignment_actions paa_run,

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
155: and asg.business_group_id = pp1.business_group_id

Line 175: pay_assignment_actions assact,

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
179: and assact.payroll_action_id = payact.payroll_action_id

Line 222: SELECT pay_assignment_actions_s.NEXTVAL

218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);
222: SELECT pay_assignment_actions_s.NEXTVAL
223: INTO l_actid
224: FROM dual;
225: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
226: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

Line 259: pay_assignment_actions paa

255: paa.payroll_action_id,
256: ppa.date_earned,
257: paa.tax_unit_id
258: from pay_payroll_actions ppa,
259: pay_assignment_actions paa
260: -- per_assignments_f asg -- Bug Fix 4260031
261: where ppa.payroll_action_id = l_pay_action_id
262: -- and asg.business_group_id = ppa.business_group_id -- Bug Fix 4260031
263: -- and asg.person_id between stperson and endperson

Line 279: pay_assignment_actions assact,

275: and ppa.report_category = 'ARCHIVE'
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

Line 312: SELECT pay_assignment_actions_s.NEXTVAL

308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;
315: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
316: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

Line 343: pay_assignment_actions paa_p30,

339: SELECT ppa_p30.payroll_action_id report_id,
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,

Line 345: pay_assignment_actions paa_arc,

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,
349: pay_action_information pact_er,

Line 347: pay_assignment_actions paa_prepay,

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
351: -- pay_pre_payments ppp -- Bug Fix 3725003

Line 375: FROM pay_assignment_actions paa_p30,

371: --
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

Line 377: pay_assignment_actions paa_arc,

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
381: AND paa_arc.assignment_action_id = pai_p30.locked_action_id

Line 387: FROM pay_assignment_actions paa_p30,

383: --
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

Line 389: pay_assignment_actions paa_arc,

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
393: AND paa_arc.assignment_action_id = pai_p30.locked_action_id

Line 414: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE,

410: -- 4317512
411: /* YTD_Balances fill fetch that balance value whose source ids effective date is less than effective date
412: of P30 datalock */
413: CURSOR YTD_Balances (vp_Payroll_Action_Id Pay_Payroll_Actions.Payroll_Action_ID%TYPE,
414: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE,
415: vp_Balance_Name Pay_Balance_Types.Balance_Name%TYPE,
416: vp_Dimension_Name varchar2,
417: vp_action_context_id number,
418: vp_effective_date date)IS -- SR 17318286.6 rbhardwa

Line 420: FROM pay_assignment_actions paa_p30,

416: vp_Dimension_Name varchar2,
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,

Line 422: pay_assignment_actions paa_arc,

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,
426: pay_balance_dimensions pbd_ytdbal,

Line 427: pay_assignment_actions paa_src,

423: pay_action_information pact_ytdbal,
424: pay_defined_balances pdb_ytdbal,
425: pay_balance_types pbt_ytdbal,
426: pay_balance_dimensions pbd_ytdbal,
427: pay_assignment_actions paa_src,
428: pay_payroll_actions ppa_src
429: WHERE paa_p30.payroll_action_id = vp_Payroll_Action_Id
430: AND paa_p30.assignment_id = vp_Assignment_Id
431: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 452: ,vp_assignment_id pay_assignment_actions.assignment_action_id%TYPE

448: ,pact_ytdbal.ACTION_CONTEXT_ID DESC
449: ,nvl(pact_ytdbal.action_information5,0) DESC;
450: --
451: CURSOR cur_get_prev_p30_lock_id (vp_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
452: ,vp_assignment_id pay_assignment_actions.assignment_action_id%TYPE
453: ,vp_tax_start_date date
454: ,vp_report_end_date date) IS
455: SELECT ppa.payroll_action_id prev_data_lock_id,
456: to_date(substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'END_DATE=')+9,10),'YYYY/MM/DD')

Line 458: ,pay_assignment_actions paa

454: ,vp_report_end_date date) IS
455: SELECT ppa.payroll_action_id prev_data_lock_id,
456: to_date(substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'END_DATE=')+9,10),'YYYY/MM/DD')
457: FROM pay_payroll_actions ppa
458: ,pay_assignment_actions paa
459: WHERE ppa.payroll_action_id = paa.payroll_action_id
460: AND ppa.report_type = 'IEP30_PRGLOCK'
461: AND paa.assignment_id = vp_assignment_id
462: AND paa.assignment_action_id = (

Line 466: ,pay_assignment_actions paa2

462: AND paa.assignment_action_id = (
463: SELECT to_number(substr(max(lpad(paa2.action_sequence,15,'0')||
464: paa2.assignment_action_id),16))--Bug No 3318509
465: FROM pay_payroll_actions ppa2
466: ,pay_assignment_actions paa2
467: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
468: AND ppa2.report_type = 'IEP30_PRGLOCK'
469: AND paa2.assignment_id = vp_assignment_id
470: AND ppa2.payroll_action_id <> vp_payroll_action_id

Line 492: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE) IS

488: /* SR 17318286.6 rbhardwa changes start here */
489: --Bug Fix 4032212 This cursor is added to get the max action_context_id against the P30 Data Lock id
490: -- Changed to fetch correct action context if Archiver is run for Period 2 first and then for period1
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,

Line 494: FROM pay_assignment_actions paa_p30,

490: -- Changed to fetch correct action context if Archiver is run for Period 2 first and then for period1
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,

Line 496: pay_assignment_actions paa_arc,

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,
500: pay_payroll_actions ppa_run

Line 499: pay_assignment_actions paa_run,

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
503: AND paa_p30.assignment_id = vp_Assignment_Id