DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 552: ,per_assignments_f asg

548: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
549: AND action_context_id IN (SELECT MAX(pai.action_context_id)
550: FROM pay_action_information pai
551: ,pay_assignment_actions paa
552: ,per_assignments_f asg
553: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
554: AND pai.action_context_id = paa.assignment_action_id
555: AND pai.action_information_category = 'IN_24QC_PERSON'
556: AND pai.action_context_type = 'AAP'