DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on CR_RSRC_DTL

Line 3792: FROM gmp_resource_instances i, cr_rsrc_dtl r

3788: , p_instance IN VARCHAR2 ) IS
3789: BEGIN
3790: OPEN x_resource_cursor FOR
3791: SELECT i.instance_number, i.instance_id
3792: FROM gmp_resource_instances i, cr_rsrc_dtl r
3793: WHERE r.resource_id = i.resource_id
3794: AND r.resources = p_resource
3795: AND r.organization_id = p_organization_id
3796: AND i.instance_number LIKE (p_instance);