DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COM_SPEC_VRS_VL

Line 1267: --RLNAGARA Bug # 4916856 Replaced gmd_all_spec_vrs with gmd_com_spec_vrs_vl

1263:
1264: PROCEDURE call_spec_match(p_hdr_rec IN OUT NOCOPY t_coa_hdr_rec,
1265: x_return_status OUT NOCOPY VARCHAR2) IS
1266:
1267: --RLNAGARA Bug # 4916856 Replaced gmd_all_spec_vrs with gmd_com_spec_vrs_vl
1268: CURSOR c_coa_type(p_spec_vr_id IN NUMBER) IS
1269: select nvl(coa_type,'A') coa_type
1270: from gmd_com_spec_vrs_vl
1271: where spec_vr_id = p_spec_vr_id;

Line 1270: from gmd_com_spec_vrs_vl

1266:
1267: --RLNAGARA Bug # 4916856 Replaced gmd_all_spec_vrs with gmd_com_spec_vrs_vl
1268: CURSOR c_coa_type(p_spec_vr_id IN NUMBER) IS
1269: select nvl(coa_type,'A') coa_type
1270: from gmd_com_spec_vrs_vl
1271: where spec_vr_id = p_spec_vr_id;
1272:
1273: CURSOR cur_spec_hdr_text(l_spec_id IN NUMBER) IS -- Bug # 4260445 Declared Cursor to get the value of text_code
1274: SELECT text_code