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_ACTION_INTERLOCKS

Line 411: pay_action_interlocks pai,

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
415: and piv.name = 'Pay Value'

Line 2270: pay_action_interlocks pai,

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
2274: pay_payroll_actions ppa_arch -- Payroll Action of Archiver

Line 2296: from pay_action_interlocks pai2,

2292: and ppa_pre.consolidation_set_id = p_consolidation_id
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

Line 2448: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment

2444: paa.effective_date effective_date, -- Effective Date of Run
2445: ppaa.effective_date pre_effective_date, -- Effective Date of Archive
2446: paa.date_earned date_earned, -- Date Earned of Run
2447: paa.time_period_id time_period_id -- Time Period Id 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

Line 2449: pay_action_interlocks pay, -- Lock of Prepayment on Run

2445: ppaa.effective_date pre_effective_date, -- Effective Date of Archive
2446: paa.date_earned date_earned, -- Date Earned of Run
2447: paa.time_period_id time_period_id -- Time Period Id 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