APPS.GMD_LAB_MIGRATION dependencies on LM_FORM_MST

Line 12: FROM lm_form_mst

8: /*Cursor to get all the formula which have no tpformula_id attached*/
9:
10: CURSOR Cur_non_tp_formula IS
11: SELECT *
12: FROM lm_form_mst
13: WHERE exists (SELECT distinct d.formula_id
14: FROM lm_form_dtl d
15: WHERE NVL(d.tpformula_id, 0) = 0
16: AND d.formula_id = formula_id)

Line 22: FROM lm_form_mst

18: /*Cursor to get all the formula which have tpformula_id attached*/
19:
20: CURSOR Cur_tp_formula IS
21: SELECT *
22: FROM lm_form_mst
23: WHERE formula_id IN (SELECT distinct d.formula_id
24: FROM lm_form_dtl d
25: WHERE NVL(d.tpformula_id, 0) > 0
26: AND d.formula_id = formula_id)

Line 57: FROM lm_form_mst

53: SELECT formula_id
54: FROM fm_form_mst
55: WHERE (formula_no, formula_vers)
56: IN (SELECT formula_no, formula_vers
57: FROM lm_form_mst
58: WHERE formula_id = V_formula_id);
59:
60: /*Cursor to create sequence of the formula_id*/
61:

Line 315: 'LM_FORM_MST AND LM_FORM_DTL',

311: source_id ,
312: target_id ,
313: message_text )
314: SELECT GMD_REQUEST_ID_S.nextval,
315: 'LM_FORM_MST AND LM_FORM_DTL',
316: 'FM_FORM_MST AND MF_MATL_DTL',
317: lab_rec.formula_id,
318: Xformula_id,
319: error_msg

Line 561: 'LM_FORM_MST AND LM_FORM_DTL',

557: source_id ,
558: target_id ,
559: message_text )
560: SELECT GMD_REQUEST_ID_S.nextval,
561: 'LM_FORM_MST AND LM_FORM_DTL',
562: 'FM_FORM_MST AND MF_MATL_DTL',
563: lab_rec.formula_id,
564: Xformula_id,
565: error_msg