DBA Data[Home] [Help]

APPS.PAY_GB_HR_HELPDESK dependencies on PAY_ACTION_INFORMATION

Line 128: pay_action_information pai, -- archived element/input value definition

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
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

Line 172: pay_action_information pai, -- archived element/input value definition

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
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

Line 217: pay_action_information pai, -- archived element/input value definition

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
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

Line 258: from pay_action_information pai

254:
255: -- cursor to fetch the current net pay value for UK
256: cursor csr_net_pay_cv (p_asg_action_id number) is
257: select ACTION_INFORMATION16
258: from pay_action_information pai
259: where pai.action_context_id = p_asg_action_id
260: and pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
261: and pai.action_context_type = 'AAP';
262:

Line 266: from pay_action_information pai,

262:
263: -- cursor to fetch the tax and earnings YTD
264: cursor csr_tx_er_ytd(p_assignment_action_id number,p_bal_name varchar2) is
265: select pai.ACTION_INFORMATION4
266: from pay_action_information pai,
267: pay_defined_balances pdb,
268: pay_balance_types pbt
269: where pai.action_context_id = p_assignment_action_id -- 182069
270: and to_char(pdb.DEFINED_BALANCE_ID) = (pai.ACTION_INFORMATION1)

Line 285: from pay_action_information pai

281: from pay_defined_balances pdb,
282: pay_balance_types pbt,
283: pay_balance_dimensions pbd
284: where pbt.balance_name = 'NI '||(select ACTION_INFORMATION23
285: from pay_action_information pai
286: where pai.action_context_id = p_assignment_action_id --182069
287: and pai.action_information_category = 'GB EMPLOYEE DETAILS'
288: and pai.action_context_type = 'AAP')
289: ||' Employee'