DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on CR_RSRC_DTL

Line 3876: FROM gmp_resource_instances i, cr_rsrc_dtl r

3872: , p_instance IN VARCHAR2 ) IS
3873: BEGIN
3874: OPEN x_resource_cursor FOR
3875: SELECT i.instance_number, i.instance_id
3876: FROM gmp_resource_instances i, cr_rsrc_dtl r
3877: WHERE r.resource_id = i.resource_id
3878: AND r.resources = p_resource
3879: AND r.organization_id = p_organization_id
3880: AND i.instance_number LIKE (p_instance);