APPS.PAY_IN_24Q_ER_RETURNS dependencies on FND_PROFILE

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

445: WHERE pai.action_information_category = 'IN_24Q_PERSON'
446: AND pai.action_context_type = 'AAP'
447: AND pai.action_information1 = asg.person_id
448: AND pai.assignment_id = asg.assignment_id
449: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
450: AND pai.action_information2 = p_assess_period
451: AND pai.action_information3 = p_gre_org_id
452: AND pai.source_id = paa.assignment_action_id
453: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9

Line 527: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

523: AND action_context_type = 'AAP'
524: AND pai.action_information1 = asg.person_id
525: AND SUBSTR(pai.action_information2,1,9) = p_assess_year
526: AND pai.action_information3 = p_gre_org_id
527: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
528: AND pai.source_id = paa.assignment_action_id
529: AND pai.assignment_id = asg.assignment_id
530: GROUP BY pai.assignment_id,action_information1,action_information9
531: );

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

730: WHERE pai.action_information_category = 'IN_24Q_PERSON'
731: AND pai.action_information3 = p_gre_org_id
732: AND pai.action_information2 = p_assess_period
733: AND pai.action_information1 = asg.person_id
734: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
735: AND asg.assignment_id = pai.assignment_id
736: AND pai.action_context_type = 'AAP'
737: AND pai.source_id = paa.assignment_action_id
738: GROUP BY pai.action_information1,pai.action_information9,source_id;