APPS.GMD_SAMPLES_GRP dependencies on GMD_SAMPLE_SPEC_DISP

Line 1682: FROM gmd_sample_spec_disp

1678: END IF;
1679:
1680: -- check whether the sample disposition has changed.if yes raise error
1681: SELECT disposition INTO l_compare_sample_disp
1682: FROM gmd_sample_spec_disp
1683: WHERE event_spec_disp_id = l_event_spec_disp_id
1684: AND sample_id = p_update_disp_rec.sample_id
1685: FOR UPDATE OF disposition NOWAIT ;
1686:

Line 1694: UPDATE gmd_sample_spec_disp

1690:
1691: l_position := '020' ;
1692:
1693: -- Set the disposition of the sample spec disp
1694: UPDATE gmd_sample_spec_disp
1695: SET disposition = p_to_disposition,
1696: last_updated_by = l_last_updated_by,
1697: last_update_date = l_last_update_date,
1698: last_update_login = l_last_update_login

Line 2036: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

2032: -- SG disp formalised here
2033:
2034: -- get MAXIMUM sample disposition from all the samples for that event.
2035: SELECT MAX(ssd.disposition) INTO l_max_disposition
2036: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
2037: WHERE esd.event_spec_disp_id = l_event_spec_disp_id
2038: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
2039: AND esd.delete_mark = 0
2040: AND ssd.delete_mark = 0

Line 2072: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

2068: END IF;
2069:
2070: SELECT MAX(ssd.disposition),MIN(ssd.disposition)
2071: INTO l_max_disposition,l_min_disposition
2072: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
2073: WHERE
2074: esd.event_spec_disp_id = l_event_spec_disp_id
2075: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
2076: AND esd.delete_mark = 0

Line 5320: FROM gmd_sample_spec_disp ssd,

5316: --RLNAGARA B5130051 modified parameter from sample_id to p_sample_id
5317: CURSOR Cur_disposition(p_sample_id NUMBER) IS
5318: SELECT l.lookup_code,
5319: l.meaning
5320: FROM gmd_sample_spec_disp ssd,
5321: gem_lookups l
5322: WHERE ssd.sample_id = p_sample_id
5323: AND l.lookup_type = 'GMD_QC_SAMPLE_DISP'
5324: AND l.lookup_code = ssd.disposition ;

Line 6264: FROM gmd_sample_spec_disp b,

6260: CURSOR Cur_get_sample_disposition IS
6261: SELECT b.disposition,
6262: d.meaning sample_disposition,
6263: e.meaning source
6264: FROM gmd_sample_spec_disp b,
6265: gmd_event_spec_disp c,
6266: gmd_samples s,
6267: fnd_lookup_values_vl d,
6268: fnd_lookup_values_vl e

Line 6281: FROM gmd_sample_spec_disp b,

6277: UNION
6278: SELECT b.disposition,
6279: d.meaning sample_disposition,
6280: e.meaning source
6281: FROM gmd_sample_spec_disp b,
6282: gmd_event_spec_disp c,
6283: gmd_samples s,
6284: fnd_lookup_values d,
6285: fnd_lookup_values e