DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 575: ,per_assignments_f asg

571: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
572: AND action_context_id IN (SELECT MAX(pai.action_context_id)
573: FROM pay_action_information pai
574: ,pay_assignment_actions paa
575: ,per_assignments_f asg
576: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
577: AND pai.action_context_id = paa.assignment_action_id
578: AND pai.action_information_category = 'IN_24QC_PERSON'
579: AND pai.action_context_type = 'AAP'