DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 92: ,per_assignments_f asg

88: AND action_information3 = p_gre_org_id
89: AND action_context_id IN ( SELECT MAX(pai.action_context_id)
90: FROM pay_action_information pai
91: ,pay_assignment_actions paa
92: ,per_assignments_f asg
93: WHERE pai.action_information_category = 'IN_EOY_PERSON'
94: AND pai.action_context_type = 'AAP'
95: AND pai.assignment_id = asg.assignment_id
96: AND paa.assignment_id = asg.assignment_id

Line 165: ,per_assignments_f asg

161: AND action_information3 = p_gre_org_id
162: AND action_context_id IN ( SELECT MAX(pai.action_context_id)
163: FROM pay_action_information pai
164: ,pay_assignment_actions paa
165: ,per_assignments_f asg
166: WHERE pai.action_information_category = 'IN_EOY_PERSON'
167: AND pai.action_context_type = 'AAP'
168: AND pai.assignment_id = asg.assignment_id
169: AND paa.assignment_id = asg.assignment_id

Line 316: ,per_assignments_f asg

312: SELECT MAX(pai.action_context_id) action_cont_id
313: ,source_id sour_id
314: FROM pay_action_information pai
315: ,pay_assignment_actions paa
316: ,per_assignments_f asg
317: WHERE pai.action_information_category = 'IN_EOY_PERSON'
318: AND pai.assignment_id = asg.assignment_id
319: AND paa.assignment_id = asg.assignment_id
320: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')