DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COM_SPEC_VRS_VL

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

1192:
1193: PROCEDURE call_spec_match(p_hdr_rec IN OUT NOCOPY t_coa_hdr_rec,
1194: x_return_status OUT NOCOPY VARCHAR2) IS
1195:
1196: --RLNAGARA Bug # 4916856 Replaced gmd_all_spec_vrs with gmd_com_spec_vrs_vl
1197: CURSOR c_coa_type(p_spec_vr_id IN NUMBER) IS
1198: select nvl(coa_type,'A') coa_type
1199: from gmd_com_spec_vrs_vl
1200: where spec_vr_id = p_spec_vr_id;

Line 1199: from gmd_com_spec_vrs_vl

1195:
1196: --RLNAGARA Bug # 4916856 Replaced gmd_all_spec_vrs with gmd_com_spec_vrs_vl
1197: CURSOR c_coa_type(p_spec_vr_id IN NUMBER) IS
1198: select nvl(coa_type,'A') coa_type
1199: from gmd_com_spec_vrs_vl
1200: where spec_vr_id = p_spec_vr_id;
1201:
1202: CURSOR cur_spec_hdr_text(l_spec_id IN NUMBER) IS -- Bug # 4260445 Declared Cursor to get the value of text_code
1203: SELECT text_code