APPS.PAY_IN_24Q_ER_RETURNS dependencies on FND_PROFILE

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

473: WHERE pai.action_information_category = 'IN_24Q_PERSON'
474: AND pai.action_context_type = 'AAP'
475: AND pai.action_information1 = asg.person_id
476: AND pai.assignment_id = asg.assignment_id
477: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
478: AND pai.action_information2 = p_assess_period
479: AND pai.action_information3 = p_gre_org_id
480: AND pai.source_id = paa.assignment_action_id
481: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9

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

551: AND action_context_type = 'AAP'
552: AND pai.action_information1 = asg.person_id
553: AND SUBSTR(pai.action_information2,1,9) = p_assess_year
554: AND pai.action_information3 = p_gre_org_id
555: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
556: AND pai.source_id = paa.assignment_action_id
557: AND pai.assignment_id = asg.assignment_id
558: GROUP BY pai.assignment_id,action_information1,action_information9
559: );

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

760: WHERE pai.action_information_category = 'IN_24Q_PERSON'
761: AND pai.action_information3 = p_gre_org_id
762: AND pai.action_information2 = p_assess_period
763: AND pai.action_information1 = asg.person_id
764: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
765: AND asg.assignment_id = pai.assignment_id
766: AND pai.action_context_type = 'AAP'
767: AND pai.source_id = paa.assignment_action_id
768: GROUP BY pai.action_information1,pai.action_information9,source_id;