2408: AND s.qc_spec_id = m.qc_spec_id ;
2409: coa_rec c_get_coa_inds%ROWTYPE;
2410:
2411:
2412: -- Bug 3859406; replaced table all_tab_columns with fnd_columns;
2413: -- per apps standards
2414: -- Revert back to all_tab_columns since the file is delivered to 11.5.10
2415: CURSOR c_patch_level IS
2416: SELECT 'K+'
2410:
2411:
2412: -- Bug 3859406; replaced table all_tab_columns with fnd_columns;
2413: -- per apps standards
2414: -- Revert back to all_tab_columns since the file is delivered to 11.5.10
2415: CURSOR c_patch_level IS
2416: SELECT 'K+'
2417: from all_tab_columns
2418: where table_name='GMD_SPECIFICATIONS_B'
2413: -- per apps standards
2414: -- Revert back to all_tab_columns since the file is delivered to 11.5.10
2415: CURSOR c_patch_level IS
2416: SELECT 'K+'
2417: from all_tab_columns
2418: where table_name='GMD_SPECIFICATIONS_B'
2419: and column_name='SPEC_TYPE'
2420: and owner = l_gmd;
2421:
3954: FROM qc_smpl_mst
3955: WHERE orgn_code = smpl_rec.orgn_code
3956: and sample_no = smpl_rec.sample_no;
3957:
3958: -- Bug 3859406; replaced table all_tab_columns with fnd_columns;
3959: -- per apps standards
3960:
3961: -- B3883674 Added following cursor
3962: -- Refer to GMD_SAMPLING_EVENTS for sample_type column
3961: -- B3883674 Added following cursor
3962: -- Refer to GMD_SAMPLING_EVENTS for sample_type column
3963: CURSOR c_patch_level1 IS
3964: SELECT 'K+'
3965: from all_tab_columns
3966: where table_name='GMD_SAMPLING_EVENTS'
3967: and column_name='SAMPLE_TYPE'
3968: and owner = l_gmd;
3969:
3969:
3970: -- B3883674 Refer to GMD_SAMPLES for sample_type column
3971: CURSOR c_patch_level2 IS
3972: SELECT 'K+'
3973: from all_tab_columns
3974: where table_name='GMD_SAMPLES'
3975: and column_name='SAMPLE_TYPE'
3976: and owner = l_gmd;
3977: