APPS.GME_MOBILE_LOVS dependencies on GMP_RESOURCE_INSTANCES

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

Line 3815: FROM gmp_resource_instances i, gme_resource_txns_gtmp t

3811: , p_instance IN VARCHAR2) IS
3812: BEGIN
3813: OPEN x_resource_cursor FOR
3814: SELECT i.instance_number, i.instance_id
3815: FROM gmp_resource_instances i, gme_resource_txns_gtmp t
3816: WHERE t.doc_id = p_batch_id
3817: AND t.line_id = p_batchstep_resource_id
3818: AND t.start_date = t.end_date
3819: AND action_code NOT IN ('REVS', 'REVL')

Line 3919: gmp_resource_instances i,

3915: FROM gme_batch_header h,
3916: gme_batch_steps s,
3917: gme_batch_step_activities a,
3918: gme_batch_step_resources r,
3919: gmp_resource_instances i,
3920: fnd_user u
3921: WHERE h.batch_id = p_batch_id
3922: AND h.batch_id = s.batch_id
3923: AND s.batchstep_no = p_step_no

Line 3971: gmp_resource_instances i,

3967: , r.usage_um
3968: FROM gme_batch_steps s,
3969: gme_batch_step_activities a,
3970: gme_batch_step_resources r,
3971: gmp_resource_instances i,
3972: gme_resource_txns_gtmp t,
3973: gme_resource_txns rt,
3974: fnd_user u
3975: WHERE