APPS.PAY_IN_EOY_ER_RETURNS dependencies on FND_PROFILE

Line 97: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

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
97: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
98: AND pai.action_information2 = p_assess_year
99: AND pai.action_information3 = p_gre_org_id
100: AND pai.source_id = paa.assignment_action_id
101: GROUP BY pai.action_information1,pai.action_information17 );

Line 170: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

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
170: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
171: AND pai.action_information2 = p_assess_year
172: AND pai.action_information3 = p_gre_org_id
173: AND pai.source_id = paa.assignment_action_id
174: GROUP BY pai.action_information1,pai.action_information17 );

Line 320: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

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')
321: AND pai.action_information3 = p_gre_org_id
322: AND pai.action_information2 = p_assess_year
323: AND pai.action_context_type = 'AAP'
324: AND pai.source_id = paa.assignment_action_id