DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ACTION_INFORMATION

Line 186: pay_action_information pai,

182: IS
183: SELECT DISTINCT paa.assignment_id,paa.assignment_action_id,paa.payroll_action_id
184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,
189: hr_soft_coding_keyflex flex
190: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 449: ,pay_action_information pact

445: count(decode(pact.action_information6,0,null,null,null,1)) EMP_RAC,
446: sum(to_number(pact.action_information6))*100 EMP_RAC_BAL,
447: sum(to_number(pact.action_information1))*100 TAXABLEBENEFITS
448: FROM pay_assignment_actions paa
449: ,pay_action_information pact
450: ,pay_action_interlocks pai
451: WHERE paa.payroll_action_id = p_payroll_action_id
452: AND paa.source_action_id IS NULL
453: AND pai.locking_action_id = paa.assignment_action_id