DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 748: ,per_assignments_f asg

744: SELECT MAX(pai.action_context_id) action_cont_id
745: ,source_id sour_id
746: FROM pay_action_information pai
747: ,pay_assignment_actions paa
748: ,per_assignments_f asg
749: WHERE paa.payroll_action_id = p_max_action_id
750: AND pai.action_context_id = paa.assignment_action_id
751: AND pai.action_information_category = 'IN_24QC_PERSON'
752: AND pai.action_information3 = p_gre_org_id

Line 852: ,per_assignments_f asg

848: AND action_information11 = p_correction_type
849: AND action_context_id IN (SELECT MAX(pai.action_context_id)
850: FROM pay_action_information pai
851: ,pay_assignment_actions paa
852: ,per_assignments_f asg
853: WHERE paa.payroll_action_id = p_max_action_id
854: AND pai.action_context_id = paa.assignment_action_id
855: AND pai.action_information_category = 'IN_24QC_PERSON'
856: AND pai.action_context_type = 'AAP'