DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on FND_PROFILE

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

557: AND pai.action_information1 = asg.person_id
558: AND pai.action_information2 = g_assess_year||g_quarter
559: AND pai.action_information3 = g_gre_org_id
560: AND pai.assignment_id = asg.assignment_id
561: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
562: AND pai.action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
563: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9
564: )
565: ORDER BY fnd_number.canonical_to_number(action_information1),assignment_id,fnd_number.canonical_to_number(action_information12) ASC;