DBA Data[Home] [Help]

APPS.GME_RESOURCE_ENGINE_PVT dependencies on CR_RSRC_DTL

Line 2103: FROM gmp_resource_instances i, cr_rsrc_dtl r

2099:
2100: CURSOR cur_get_instance_id (v_instance_no NUMBER, v_resource VARCHAR2)
2101: IS
2102: SELECT instance_id
2103: FROM gmp_resource_instances i, cr_rsrc_dtl r
2104: WHERE r.resource_id = i.resource_id
2105: AND r.resources = v_resource
2106: AND instance_number = v_instance_no;
2107:

Line 2113: FROM gmp_resource_instances i, cr_rsrc_dtl r

2109: v_instance_id NUMBER
2110: ,v_resource VARCHAR2)
2111: IS
2112: SELECT 1
2113: FROM gmp_resource_instances i, cr_rsrc_dtl r
2114: WHERE r.resource_id = i.resource_id
2115: AND r.resources = v_resource
2116: AND instance_id = v_instance_id;
2117: