APPS.GME_MOBILE_LOVS dependencies on GMP_RESOURCE_INSTANCES

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);

Line 3899: FROM gmp_resource_instances i, gme_resource_txns_gtmp t

3895: , p_instance IN VARCHAR2) IS
3896: BEGIN
3897: OPEN x_resource_cursor FOR
3898: SELECT i.instance_number, i.instance_id
3899: FROM gmp_resource_instances i, gme_resource_txns_gtmp t
3900: WHERE t.doc_id = p_batch_id
3901: AND t.line_id = p_batchstep_resource_id
3902: AND t.start_date = t.end_date
3903: AND action_code NOT IN ('REVS', 'REVL')

Line 4003: gmp_resource_instances i,

3999: FROM gme_batch_header h,
4000: gme_batch_steps s,
4001: gme_batch_step_activities a,
4002: gme_batch_step_resources r,
4003: gmp_resource_instances i,
4004: fnd_user u
4005: WHERE h.batch_id = p_batch_id
4006: AND h.batch_id = s.batch_id
4007: AND s.batchstep_no = p_step_no

Line 4055: gmp_resource_instances i,

4051: , r.usage_um
4052: FROM gme_batch_steps s,
4053: gme_batch_step_activities a,
4054: gme_batch_step_resources r,
4055: gmp_resource_instances i,
4056: gme_resource_txns_gtmp t,
4057: gme_resource_txns rt,
4058: fnd_user u
4059: WHERE