DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on FND_PROFILE

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

580: AND pai.action_information1 = asg.person_id
581: AND pai.action_information2 = g_assess_year||g_quarter
582: AND pai.action_information3 = g_gre_org_id
583: AND pai.assignment_id = asg.assignment_id
584: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
585: AND pai.action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
586: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9
587: )
588: ORDER BY fnd_number.canonical_to_number(action_information1),assignment_id,fnd_number.canonical_to_number(action_information12) ASC;