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 400: pay_action_interlocks pai,

396: pay_run_results prr,
397: pay_element_classifications pec,
398: pay_assignment_actions paa, -- Assignment Action of Prepayments
399: pay_assignment_actions rpaa, -- Assignment Action of Run
400: pay_action_interlocks pai,
401: pay_payroll_actions ppa -- Payroll Action of Prepayments
402: where pet.element_type_id = prr.element_type_id
403: and piv.element_type_id = pet.element_type_id
404: and piv.name = 'Pay Value'

Line 2010: pay_action_interlocks pai,

2006: paa_run.assignment_action_id run_action_id,
2007: paa_pre.assignment_action_id prepaid_action_id
2008: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2009: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2013: pay_payroll_actions ppa_run, -- Payroll Action of Run
2014: pay_payroll_actions ppa_arch -- Payroll Action of Archiver

Line 2036: from pay_action_interlocks pai2,

2032: and ppa_pre.consolidation_set_id = p_consolidation_id
2033: and not exists -- You can comment this to make the Archive rerunable
2034: (
2035: select /*+ ORDERED */ NULL
2036: from pay_action_interlocks pai2,
2037: pay_assignment_actions paa_arch2, -- Assignment Action of Archiver
2038: pay_payroll_actions ppa_arch2 -- Payroll Action of Archiver
2039: where pai2.locked_action_id = paa_run.assignment_action_id
2040: and paa_arch2.assignment_action_id = pai2.locking_action_id

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

2184: paa.effective_date effective_date, -- Effective Date of Run
2185: ppaa.effective_date pre_effective_date, -- Effective Date of Archive
2186: paa.date_earned date_earned, -- Date Earned of Run
2187: paa.time_period_id time_period_id -- Time Period Id of Run
2188: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2189: pay_action_interlocks pay, -- Lock of Prepayment on Run
2190: pay_payroll_actions paa, -- Payroll Action of Run
2191: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2192: pay_assignment_actions assact, -- Assignment Action of Run

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

2185: ppaa.effective_date pre_effective_date, -- Effective Date of Archive
2186: paa.date_earned date_earned, -- Date Earned of Run
2187: paa.time_period_id time_period_id -- Time Period Id of Run
2188: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2189: pay_action_interlocks pay, -- Lock of Prepayment on Run
2190: pay_payroll_actions paa, -- Payroll Action of Run
2191: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2192: pay_assignment_actions assact, -- Assignment Action of Run
2193: pay_assignment_actions passact -- Assignment Action of Archiver