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;