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 237: FROM gmd_tech_parameters_b

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