APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 3940: FROM pa_resource_list_members pr

3936: -- Bug 2605070, Only one stmt is needed to update the parent_resource_id
3937: UPDATE gms_bc_packets gms
3938: SET (parent_resource_id) =
3939: (SELECT pr.parent_member_id
3940: FROM pa_resource_list_members pr
3941: WHERE pr.resource_list_member_id = gms.resource_list_member_id
3942: AND ROWNUM = 1)
3943: WHERE packet_id = x_packetid
3944: AND status_code = 'P'