DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 265: pay_action_interlocks plock

261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,
265: pay_action_interlocks plock
266: WHERE ppa_p35.report_type = 'IEP35MAG'
267: AND paa_p35.action_status = 'C'
268: AND TO_DATE (
269: pay_ie_p35.get_parameter (

Line 450: ,pay_action_interlocks pai

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
454: AND pact.action_context_id = pai.locked_action_id