DBA Data[Home] [Help]

APPS.GMD_DISP_PUB dependencies on GMD_SAMPLE_SPEC_DISP

Line 1041: -- Get current disposition of Sample from gmd_sample_spec_disp

1037: AND a.organization_id = e.organization_id;
1038:
1039: l_pos := '003';
1040:
1041: -- Get current disposition of Sample from gmd_sample_spec_disp
1042: SELECT a.DISPOSITION,
1043: b.EVENT_SPEC_DISP_ID,
1044: b.spec_id,b.spec_vr_id,
1045: c.spec_name,

Line 1050: FROM gmd_sample_spec_disp a,

1046: c.spec_vers
1047: INTO l_update_disp_rec.curr_disposition,l_update_disp_rec.event_spec_disp_id,
1048: l_spec_id,l_spec_vr_id,
1049: l_spec_name,l_spec_vers
1050: FROM gmd_sample_spec_disp a,
1051: gmd_event_spec_disp b,
1052: gmd_specifications_b c
1053: WHERE a.sample_id = l_update_disp_rec.sample_id
1054: AND a.event_spec_disp_id = b.event_spec_disp_id