APPS.GMD_LAB_MIGRATION dependencies on LM_FORM_DTL

Line 14: FROM lm_form_dtl d

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)
17: order by formula_no, formula_vers;
18: /*Cursor to get all the formula which have tpformula_id attached*/

Line 24: FROM lm_form_dtl d

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)
27: order by formula_no, formula_vers;
28:

Line 68: select * from lm_form_dtl

64:
65: /*Cursor to get all formula details for a given formula_id */
66:
67: CURSOR lab_detail (Vformula_id IN NUMBER) is
68: select * from lm_form_dtl
69: where formula_id = Vformula_id ;
70:
71: /*Cursor to create sequence of the formulaline_id */
72:

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