APPS.HR_PERSON_RECORD dependencies on PAY_ACTION_INTERLOCKS

Line 2174: FROM pay_action_interlocks lck, -- archive action locking prepayment

2170: cursor csr_uk_earnings_cv(p_assignment_action_id number) is
2171: SELECT /*+ leading(lck,paa2) */
2172: --pai.action_information4 NARRATIVE,
2173: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2174: FROM pay_action_interlocks lck, -- archive action locking prepayment
2175: pay_assignment_actions paa1, -- prepayment action
2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition

Line 2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

2175: pay_assignment_actions paa1, -- prepayment action
2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition
2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2180: pay_assignment_actions paa, -- payroll run/quickpay action
2181: pay_payroll_actions ppa1, -- payroll run/quickpay action
2182: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2183: pay_input_values_f piv, -- "Pay values" of type Money

Line 2218: FROM pay_action_interlocks lck, -- archive action locking prepayment

2214: -- cursor to fetch the tax and national insurance current value
2215: cursor csr_uk_tx_cv(p_assignment_action_id number) is
2216: SELECT /*+ leading(lck,paa2) */
2217: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2218: FROM pay_action_interlocks lck, -- archive action locking prepayment
2219: pay_assignment_actions paa1, -- prepayment action
2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition

Line 2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

2219: pay_assignment_actions paa1, -- prepayment action
2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition
2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2224: pay_assignment_actions paa, -- payroll run/quickpay action
2225: pay_payroll_actions ppa1, -- payroll run/quickpay action
2226: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2227: pay_input_values_f piv, -- "Pay values" of type Money

Line 2263: FROM pay_action_interlocks lck, -- archive action locking prepayment

2259: -- cursor to fetch the tax and national insurance current value
2260: cursor csr_uk_ni_cv(p_assignment_action_id number) is
2261: SELECT /*+ leading(lck,paa2) */
2262: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2263: FROM pay_action_interlocks lck, -- archive action locking prepayment
2264: pay_assignment_actions paa1, -- prepayment action
2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition

Line 2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

2264: pay_assignment_actions paa1, -- prepayment action
2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition
2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2269: pay_assignment_actions paa, -- payroll run/quickpay action
2270: pay_payroll_actions ppa1, -- payroll run/quickpay action
2271: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2272: pay_input_values_f piv, -- "Pay values" of type Money