APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 4246: FROM pa_resource_list_members pr

4242: -- Bug 2605070, Only one stmt is needed to update the parent_resource_id
4243: UPDATE gms_bc_packets gms
4244: SET (parent_resource_id) =
4245: (SELECT pr.parent_member_id
4246: FROM pa_resource_list_members pr
4247: WHERE pr.resource_list_member_id = gms.resource_list_member_id
4248: AND ROWNUM = 1)
4249: WHERE packet_id = x_packetid
4250: AND status_code = 'P'