DBA Data[Home] [Help]

APPS.GME_RESOURCE_ENGINE_PVT dependencies on CR_RSRC_DTL

Line 1983: FROM gmp_resource_instances i, cr_rsrc_dtl r

1979:
1980: CURSOR cur_get_instance_id (v_instance_no NUMBER, v_resource VARCHAR2)
1981: IS
1982: SELECT instance_id
1983: FROM gmp_resource_instances i, cr_rsrc_dtl r
1984: WHERE r.resource_id = i.resource_id
1985: AND r.resources = v_resource
1986: AND instance_number = v_instance_no;
1987:

Line 1993: FROM gmp_resource_instances i, cr_rsrc_dtl r

1989: v_instance_id NUMBER
1990: ,v_resource VARCHAR2)
1991: IS
1992: SELECT 1
1993: FROM gmp_resource_instances i, cr_rsrc_dtl r
1994: WHERE r.resource_id = i.resource_id
1995: AND r.resources = v_resource
1996: AND instance_id = v_instance_id;
1997: