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: ,pay_action_information pai --12943478
155: where pp1.payroll_action_id = pactid

Line 181: pay_assignment_actions assact,

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

Line 228: SELECT pay_assignment_actions_s.NEXTVAL

224: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
225: hr_utility.set_location('pactid_id ' || pactid,15);
226: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
227: hr_utility.set_location('-----------------------------------------',17);
228: SELECT pay_assignment_actions_s.NEXTVAL
229: INTO l_actid
230: FROM dual;
231: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
232: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

Line 265: pay_assignment_actions paa

261: paa.payroll_action_id,
262: ppa.date_earned,
263: paa.tax_unit_id
264: from pay_payroll_actions ppa,
265: pay_assignment_actions paa
266: -- per_assignments_f asg -- Bug Fix 4260031
267: where ppa.payroll_action_id = l_pay_action_id
268: -- and asg.business_group_id = ppa.business_group_id -- Bug Fix 4260031
269: -- and asg.person_id between stperson and endperson

Line 285: pay_assignment_actions assact,

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

Line 318: SELECT pay_assignment_actions_s.NEXTVAL

314: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
315: hr_utility.set_location('Pact_id ' || pactid,15);
316: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
317: hr_utility.set_location('-----------------------------------------',17);
318: SELECT pay_assignment_actions_s.NEXTVAL
319: INTO l_actid
320: FROM dual;
321: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
322: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

Line 349: pay_assignment_actions paa_p30,

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

Line 351: pay_assignment_actions paa_arc,

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

Line 353: pay_assignment_actions paa_prepay,

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

Line 381: FROM pay_assignment_actions paa_p30,

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

Line 383: pay_assignment_actions paa_arc,

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

Line 393: FROM pay_assignment_actions paa_p30,

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

Line 395: pay_assignment_actions paa_arc,

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

Line 420: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE,

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

Line 426: FROM pay_assignment_actions paa_p30,

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

Line 428: pay_assignment_actions paa_arc,

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

Line 433: pay_assignment_actions paa_src,

429: pay_action_information pact_ytdbal,
430: pay_defined_balances pdb_ytdbal,
431: pay_balance_types pbt_ytdbal,
432: pay_balance_dimensions pbd_ytdbal,
433: pay_assignment_actions paa_src,
434: pay_payroll_actions ppa_src
435: WHERE paa_p30.payroll_action_id = vp_Payroll_Action_Id
436: AND paa_p30.assignment_id = vp_Assignment_Id
437: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 458: ,vp_assignment_id pay_assignment_actions.assignment_action_id%TYPE

454: ,pact_ytdbal.ACTION_CONTEXT_ID DESC
455: ,nvl(pact_ytdbal.action_information5,0) DESC;
456: --
457: CURSOR cur_get_prev_p30_lock_id (vp_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
458: ,vp_assignment_id pay_assignment_actions.assignment_action_id%TYPE
459: ,vp_tax_start_date date
460: ,vp_report_end_date date) IS
461: SELECT ppa.payroll_action_id prev_data_lock_id,
462: to_date(substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'END_DATE=')+9,10),'YYYY/MM/DD')

Line 464: ,pay_assignment_actions paa

460: ,vp_report_end_date date) IS
461: SELECT ppa.payroll_action_id prev_data_lock_id,
462: to_date(substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'END_DATE=')+9,10),'YYYY/MM/DD')
463: FROM pay_payroll_actions ppa
464: ,pay_assignment_actions paa
465: WHERE ppa.payroll_action_id = paa.payroll_action_id
466: AND ppa.report_type = 'IEP30_PRGLOCK'
467: AND paa.assignment_id = vp_assignment_id
468: AND paa.assignment_action_id = (

Line 472: ,pay_assignment_actions paa2

468: AND paa.assignment_action_id = (
469: SELECT to_number(substr(max(lpad(paa2.action_sequence,15,'0')||
470: paa2.assignment_action_id),16))--Bug No 3318509
471: FROM pay_payroll_actions ppa2
472: ,pay_assignment_actions paa2
473: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
474: AND ppa2.report_type = 'IEP30_PRGLOCK'
475: AND paa2.assignment_id = vp_assignment_id
476: AND ppa2.payroll_action_id <> vp_payroll_action_id

Line 498: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE) IS

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

Line 500: FROM pay_assignment_actions paa_p30,

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

Line 502: pay_assignment_actions paa_arc,

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

Line 505: pay_assignment_actions paa_run,

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