APPS.GMD_LAB_ORGN_MIGRATION dependencies on SY_ORGN_MST

Line 20: where not exists ( select 1 from sy_orgn_mst

16:
17: BEGIN
18:
19: FOR cur_lab_tmp IN (SELECT * FROM lm_ltyp_mst l
20: where not exists ( select 1 from sy_orgn_mst
21: where orgn_code = l.lab_type)) LOOP
22: Begin
23:
24: /* Get the text code */

Line 51: INSERT INTO sy_orgn_mst (orgn_code,

47: ELSE
48: l_text_code := NULL;
49: END IF; /* End of get text code logic */
50:
51: INSERT INTO sy_orgn_mst (orgn_code,
52: parent_orgn_code,
53: co_code,
54: orgn_name,
55: plant_ind,

Line 91: 'SY_ORGN_MST',

87: target_id ,
88: message_text )
89: SELECT GMD_REQUEST_ID_S.nextval,
90: 'LM_LTYP_MST',
91: 'SY_ORGN_MST',
92: Cur_lab_tmp.lab_type,
93: Cur_lab_tmp.lab_type,
94: error_msg
95: FROM DUAL ;