DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on FND_PROFILE

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

751: AND pai.action_information_category = 'IN_24QC_PERSON'
752: AND pai.action_information3 = p_gre_org_id
753: AND pai.action_information2 = p_assess_period
754: AND pai.action_information1 = asg.person_id
755: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
756: AND asg.assignment_id = pai.assignment_id
757: AND pai.action_context_type = 'AAP'
758: AND pai.action_information11 = 'C4'
759: GROUP BY pai.action_information1,pai.action_information9,source_id;

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

855: AND pai.action_information_category = 'IN_24QC_PERSON'
856: AND pai.action_context_type = 'AAP'
857: AND pai.action_information1 = asg.person_id
858: AND pai.assignment_id = asg.assignment_id
859: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
860: AND pai.action_information2 = p_assess_period
861: AND pai.action_information3 = p_gre_org_id
862: AND pai.action_information11 = p_correction_type
863: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9