DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PAY_ACTION_INFORMATION

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

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

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

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

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

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

Line 2308: from pay_action_information pai

2304:
2305: -- cursor to fetch the current net pay value for UK
2306: cursor csr_net_pay_cv (p_asg_action_id number) is
2307: select ACTION_INFORMATION16
2308: from pay_action_information pai
2309: where pai.action_context_id = p_asg_action_id
2310: and pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2311: and pai.action_context_type = 'AAP';
2312:

Line 2316: from pay_action_information pai,

2312:
2313: -- cursor to fetch the tax and earnings YTD
2314: cursor csr_tx_er_ytd(p_assignment_action_id number,p_bal_name varchar2) is
2315: select pai.ACTION_INFORMATION4
2316: from pay_action_information pai,
2317: pay_defined_balances pdb,
2318: pay_balance_types pbt
2319: where pai.action_context_id = p_assignment_action_id -- 182069
2320: and to_char(pdb.DEFINED_BALANCE_ID) = (pai.ACTION_INFORMATION1)

Line 2335: from pay_action_information pai

2331: from pay_defined_balances pdb,
2332: pay_balance_types pbt,
2333: pay_balance_dimensions pbd
2334: where pbt.balance_name = 'NI '||(select ACTION_INFORMATION23
2335: from pay_action_information pai
2336: where pai.action_context_id = p_assignment_action_id --182069
2337: and pai.action_information_category = 'GB EMPLOYEE DETAILS'
2338: and pai.action_context_type = 'AAP')
2339: ||' Employee'