DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1080: FROM pa_resource_list_members

1076: AND pkt.top_task_id IS NULL;
1077:
1078: UPDATE gms_bc_packets pkt
1079: SET pkt.parent_resource_id = (SELECT parent_member_id
1080: FROM pa_resource_list_members
1081: WHERE resource_list_member_id = pkt.resource_list_member_id)
1082: WHERE pkt.packet_id = x_packet_id
1083: AND pkt.parent_resource_id IS NULL;
1084:

Line 1146: from pa_resource_list_members

1142: l_stage := 'Derive Parent Resource';
1143:
1144: Select parent_member_id
1145: into l_parent_resource_id
1146: from pa_resource_list_members
1147: where resource_list_member_id = p_rlmi;
1148:
1149: -- Get budget_version_id
1150: l_stage := 'Derive Budget Version';