DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on PA_RESOURCE_LIST_MEMBERS

Line 813: FROM pa_resource_list_members

809: AND pkt.top_task_id IS NULL;
810:
811: UPDATE gms_bc_packets pkt
812: SET pkt.parent_resource_id = (SELECT parent_member_id
813: FROM pa_resource_list_members
814: WHERE resource_list_member_id = pkt.resource_list_member_id)
815: WHERE pkt.packet_id = x_packet_id
816: AND pkt.parent_resource_id IS NULL;
817:

Line 879: from pa_resource_list_members

875: l_stage := 'Derive Parent Resource';
876:
877: Select parent_member_id
878: into l_parent_resource_id
879: from pa_resource_list_members
880: where resource_list_member_id = p_rlmi;
881:
882: -- Get budget_version_id
883: l_stage := 'Derive Budget Version';