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_ZA_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 409: pay_assignment_actions paa, -- Assignment Action of Prepayments

405: from pay_element_types_f pet,
406: pay_input_values_f piv,
407: pay_run_results prr,
408: pay_element_classifications pec,
409: pay_assignment_actions paa, -- Assignment Action of Prepayments
410: pay_assignment_actions rpaa, -- Assignment Action of Run
411: pay_action_interlocks pai,
412: pay_payroll_actions ppa -- Payroll Action of Prepayments
413: where pet.element_type_id = prr.element_type_id

Line 410: pay_assignment_actions rpaa, -- Assignment Action of Run

406: pay_input_values_f piv,
407: pay_run_results prr,
408: pay_element_classifications pec,
409: pay_assignment_actions paa, -- Assignment Action of Prepayments
410: pay_assignment_actions rpaa, -- Assignment Action of Run
411: pay_action_interlocks pai,
412: pay_payroll_actions ppa -- Payroll Action of Prepayments
413: where pet.element_type_id = prr.element_type_id
414: and piv.element_type_id = pet.element_type_id

Line 1649: from pay_assignment_actions paa,

1645: pay_run_results prr
1646: where prr.status in ('P', 'PA')
1647: and prv.run_result_id = prr.run_result_id
1648: and prr.assignment_action_id in (select paa.assignment_action_id
1649: from pay_assignment_actions paa,
1650: pay_assignment_actions paa1
1651: where paa.source_action_id =paa1.source_action_id
1652: and paa1.assignment_action_id = p_assignment_action_id
1653: )

Line 1650: pay_assignment_actions paa1

1646: where prr.status in ('P', 'PA')
1647: and prv.run_result_id = prr.run_result_id
1648: and prr.assignment_action_id in (select paa.assignment_action_id
1649: from pay_assignment_actions paa,
1650: pay_assignment_actions paa1
1651: where paa.source_action_id =paa1.source_action_id
1652: and paa1.assignment_action_id = p_assignment_action_id
1653: )
1654: and prr.element_type_id = p_element_type_id

Line 2269: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment

2265: select paa_run.assignment_id assignment_id,
2266: paa_run.assignment_action_id run_action_id,
2267: paa_pre.assignment_action_id prepaid_action_id
2268: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2269: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2270: pay_action_interlocks pai,
2271: per_all_assignments_f paaf,
2272: pay_assignment_actions paa_run, -- Assignment Action of Run
2273: pay_payroll_actions ppa_run, -- Payroll Action of Run

Line 2272: pay_assignment_actions paa_run, -- Assignment Action of Run

2268: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2269: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2270: pay_action_interlocks pai,
2271: per_all_assignments_f paaf,
2272: pay_assignment_actions paa_run, -- Assignment Action of Run
2273: pay_payroll_actions ppa_run, -- Payroll Action of Run
2274: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2275: where ppa_arch.payroll_action_id = p_pact_id
2276: and ppa_run.action_type in ('R', 'Q') -- Payroll Run or Quickpay Run

Line 2297: pay_assignment_actions paa_arch2, -- Assignment Action of Archiver

2293: and not exists -- You can comment this to make the Archive rerunable
2294: (
2295: select /*+ ORDERED */ NULL
2296: from pay_action_interlocks pai2,
2297: pay_assignment_actions paa_arch2, -- Assignment Action of Archiver
2298: pay_payroll_actions ppa_arch2 -- Payroll Action of Archiver
2299: where pai2.locked_action_id = paa_run.assignment_action_id
2300: and paa_arch2.assignment_action_id = pai2.locking_action_id
2301: and paa_arch2.payroll_action_id = ppa_arch2.payroll_action_id

Line 2394: select pay_assignment_actions_s.nextval

2390:
2391: if l_prepay_action_id <> csr_rec.prepaid_action_id then
2392:
2393: -- Select the next Assignment Action ID
2394: select pay_assignment_actions_s.nextval
2395: into l_actid
2396: from dual;
2397:
2398: -- retrieve the tax_unit_id

Line 2452: pay_assignment_actions assact, -- Assignment Action of Run

2448: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2449: pay_action_interlocks pay, -- Lock of Prepayment on Run
2450: pay_payroll_actions paa, -- Payroll Action of Run
2451: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2452: pay_assignment_actions assact, -- Assignment Action of Run
2453: pay_assignment_actions passact -- Assignment Action of Archiver
2454: where pre.locked_action_id = pay.locking_action_id
2455: and pre.locking_action_id = p_locking_action_id -- Assignment Action of Archiver
2456: and pre.locked_action_id = passact.assignment_action_id

Line 2453: pay_assignment_actions passact -- Assignment Action of Archiver

2449: pay_action_interlocks pay, -- Lock of Prepayment on Run
2450: pay_payroll_actions paa, -- Payroll Action of Run
2451: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2452: pay_assignment_actions assact, -- Assignment Action of Run
2453: pay_assignment_actions passact -- Assignment Action of Archiver
2454: where pre.locked_action_id = pay.locking_action_id
2455: and pre.locking_action_id = p_locking_action_id -- Assignment Action of Archiver
2456: and pre.locked_action_id = passact.assignment_action_id
2457: and passact.payroll_action_id = ppaa.payroll_action_id

Line 2476: from pay_assignment_actions paa, -- Assignment Action of Child Run

2472: p_effective_date date
2473: ) is
2474: select paa.assignment_action_id child_assignment_action_id,
2475: 'S' run_type -- Separate Payment Run
2476: from pay_assignment_actions paa, -- Assignment Action of Child Run
2477: pay_run_types_f prt
2478: where paa.source_action_id = p_master_assignment_action -- Assignment Action of Master Run
2479: and paa.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2480: and paa.assignment_id = p_assignment_id

Line 2487: from pay_assignment_actions paa

2483: and p_effective_date between prt.effective_start_date and prt.effective_end_date
2484: union
2485: select paa.assignment_action_id child_assignment_action_id,
2486: 'NP' run_type -- Standard Run, Process Separate Run
2487: from pay_assignment_actions paa
2488: where paa.payroll_action_id = p_payroll_action_id
2489: and paa.assignment_id = p_assignment_id
2490: and paa.action_sequence =
2491: (

Line 2493: from pay_assignment_actions paa1,

2489: and paa.assignment_id = p_assignment_id
2490: and paa.action_sequence =
2491: (
2492: select max(paa1.action_sequence)
2493: from pay_assignment_actions paa1,
2494: pay_run_types_f prt1
2495: where prt1.run_type_id = paa1.run_type_id
2496: and prt1.run_method in ('N', 'P')
2497: and paa1.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run

Line 2512: from pay_assignment_actions paa,

2508: p_effective_date date
2509: ) is
2510: select paa.assignment_action_id np_assignment_action_id,
2511: prt.run_method
2512: from pay_assignment_actions paa,
2513: pay_run_types_f prt
2514: where paa.source_action_id = p_assignment_action_id
2515: and paa.payroll_action_id = p_payroll_action_id
2516: and paa.assignment_id = p_assignment_id

Line 2556: from pay_assignment_actions paa

2552:
2553: -- Retrieve the chunk number for the current assignment action
2554: select paa.chunk_number
2555: into l_chunk_number
2556: from pay_assignment_actions paa
2557: where paa.assignment_action_id = p_assactid;
2558:
2559: l_action_context_id := p_assactid; --Assignment Action of Archiver
2560:

Line 2630: SELECT pay_assignment_actions_s.NEXTVAL

2626:
2627: exit when csr_child_actions%notfound;
2628:
2629: -- create additional archive assignment actions and interlocks
2630: SELECT pay_assignment_actions_s.NEXTVAL
2631: INTO l_actid
2632: FROM dual;
2633:
2634: hr_utility.set_location('csr_child_rec.run_type = ' ||