APPS.GMD_LM_MIGRATION dependencies on GMD_TECH_PARAMETERS_B

Line 25: FROM GMD_TECH_PARAMETERS_B B

21: CURSOR C_get_tech_parms IS
22: SELECT
23: B.tech_parm_name,
24: B.orgn_code
25: FROM GMD_TECH_PARAMETERS_B B
26: WHERE B.orgn_code IS NOT NULL
27: AND B.tech_parm_id = 0;
28:
29: l_row_id VARCHAR2(40);

Line 39: UPDATE gmd_tech_parameters_b

35: SELECT gmd_tech_parm_id_s.nextval INTO l_tech_parm_id
36: FROM sys.dual;
37:
38: /* Create tech_parm_id for the hdr table - lm_tech_hdr */
39: UPDATE gmd_tech_parameters_b
40: SET tech_parm_id = l_tech_parm_id
41: WHERE tech_parm_name = C_get_tech_parms_rec.tech_parm_name
42: AND orgn_code = C_get_tech_parms_rec.orgn_code;
43:

Line 165: FROM gmd_tech_parameters_b

161: PROCEDURE populate_parsed_expressions IS
162:
163: CURSOR C_get_exp_tech_parm IS
164: SELECT *
165: FROM gmd_tech_parameters_b
166: WHERE data_type = 4 OR data_type = 11
167: ORDER by tech_parm_id;
168:
169: l_return_status VARCHAR2(1) := 'S';

Line 306: FROM gmd_tech_parameters_b

302:
303: CURSOR C_get_tech_parm_id(vtech_parm_name VARCHAR2
304: ,vorgn_code VARCHAR2) IS
305: SELECT tech_parm_id
306: FROM gmd_tech_parameters_b
307: WHERE tech_parm_name = vtech_parm_name
308: AND orgn_code = vorgn_code;
309:
310: l_tech_parm_id NUMBER;

Line 534: FROM gmd_tech_parameters_b

530:
531: CURSOR C_get_tech_parm_id(vtech_parm_name VARCHAR2
532: ,vorgn_code VARCHAR2) IS
533: SELECT tech_parm_id
534: FROM gmd_tech_parameters_b
535: WHERE tech_parm_name = vtech_parm_name
536: AND orgn_code = vorgn_code;
537:
538: l_tech_parm_id NUMBER;