DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on GMD_TECH_PARAMETERS_B

Line 45: FROM gmd_tech_parameters_b

41:
42: -- Cursor to fetch data type for the technical parameter passed
43: CURSOR get_tech_data_type (l_tech_parm_id NUMBER, l_orgn_id NUMBER) IS
44: SELECT data_type
45: FROM gmd_tech_parameters_b
46: WHERE tech_parm_id = l_tech_parm_id
47: AND (organization_id = l_orgn_id OR organization_id IS NULL);
48:
49: l_text_data VARCHAR2(200) := NULL;

Line 235: FROM gmd_tech_parameters_b

231:
232: -- Cursor to fetch data type for the technical parameter passed
233: CURSOR get_tech_data_type (l_tech_parm_id NUMBER, l_orgn_id NUMBER) IS
234: SELECT data_type
235: FROM gmd_tech_parameters_b
236: WHERE tech_parm_id = l_tech_parm_id
237: AND (organization_id = l_orgn_id OR organization_id IS NULL);
238:
239: CURSOR get_Orgn_id IS