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_GB_HR_HELPDESK dependencies on PAY_ACTION_INTERLOCKS

Line 86: from pay_action_interlocks lck,

82:
83: -- cursor to fetch the run type
84: cursor csr_run_type(p_assignment_action_id number) is
85: select prtf.run_type_name
86: from pay_action_interlocks lck,
87: pay_assignment_actions paa1,
88: pay_action_interlocks pac,
89: pay_assignment_actions paa,
90: pay_run_types_f prtf

Line 88: pay_action_interlocks pac,

84: cursor csr_run_type(p_assignment_action_id number) is
85: select prtf.run_type_name
86: from pay_action_interlocks lck,
87: pay_assignment_actions paa1,
88: pay_action_interlocks pac,
89: pay_assignment_actions paa,
90: pay_run_types_f prtf
91: where lck.locked_action_id = paa1.assignment_action_id
92: and paa1.assignment_action_id = pac.locking_action_id

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

120: cursor csr_uk_earnings_cv(p_assignment_action_id number) is
121: SELECT /*+ leading(lck,paa2) */
122: --pai.action_information4 NARRATIVE,
123: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
124: FROM pay_action_interlocks lck, -- archive action locking prepayment
125: pay_assignment_actions paa1, -- prepayment action
126: pay_assignment_actions paa2, -- archive action
127: pay_payroll_actions ppa, -- prepayment
128: pay_action_information pai, -- archived element/input value definition

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

125: pay_assignment_actions paa1, -- prepayment action
126: pay_assignment_actions paa2, -- archive action
127: pay_payroll_actions ppa, -- prepayment
128: pay_action_information pai, -- archived element/input value definition
129: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
130: pay_assignment_actions paa, -- payroll run/quickpay action
131: pay_payroll_actions ppa1, -- payroll run/quickpay action
132: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
133: pay_input_values_f piv, -- "Pay values" of type Money

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

164: -- cursor to fetch the tax and national insurance current value
165: cursor csr_uk_tx_cv(p_assignment_action_id number) is
166: SELECT /*+ leading(lck,paa2) */
167: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
168: FROM pay_action_interlocks lck, -- archive action locking prepayment
169: pay_assignment_actions paa1, -- prepayment action
170: pay_assignment_actions paa2, -- archive action
171: pay_payroll_actions ppa, -- prepayment
172: pay_action_information pai, -- archived element/input value definition

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

169: pay_assignment_actions paa1, -- prepayment action
170: pay_assignment_actions paa2, -- archive action
171: pay_payroll_actions ppa, -- prepayment
172: pay_action_information pai, -- archived element/input value definition
173: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
174: pay_assignment_actions paa, -- payroll run/quickpay action
175: pay_payroll_actions ppa1, -- payroll run/quickpay action
176: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
177: pay_input_values_f piv, -- "Pay values" of type Money

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

209: -- cursor to fetch the tax and national insurance current value
210: cursor csr_uk_ni_cv(p_assignment_action_id number) is
211: SELECT /*+ leading(lck,paa2) */
212: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
213: FROM pay_action_interlocks lck, -- archive action locking prepayment
214: pay_assignment_actions paa1, -- prepayment action
215: pay_assignment_actions paa2, -- archive action
216: pay_payroll_actions ppa, -- prepayment
217: pay_action_information pai, -- archived element/input value definition

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

214: pay_assignment_actions paa1, -- prepayment action
215: pay_assignment_actions paa2, -- archive action
216: pay_payroll_actions ppa, -- prepayment
217: pay_action_information pai, -- archived element/input value definition
218: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
219: pay_assignment_actions paa, -- payroll run/quickpay action
220: pay_payroll_actions ppa1, -- payroll run/quickpay action
221: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
222: pay_input_values_f piv, -- "Pay values" of type Money