APPS.GMD_EXPRESSION_UTIL dependencies on GMD_TECH_PARAMETERS_B

Line 34: FROM gmd_parsed_expression p, gmd_tech_parameters_b b

30: CONNECT BY PRIOR expression_parm_id = p.tech_parm_id
31: AND (p.data_type <> 11 OR p.tech_parm_id <> p.expression_parm_id);
32:
33: /*SELECT max(level)
34: FROM gmd_parsed_expression p, gmd_tech_parameters_b b
35: WHERE expression_type <> -1
36: AND p.tech_parm_id = b.tech_parm_id (+)
37: START WITH p.tech_parm_id = V_tech_parm_id
38: CONNECT BY PRIOR expression_parm_id = p.tech_parm_id

Line 110: FROM gmd_tech_parameters_b b

106: SET expression_type = -1,
107: expression_parm_id = P_tech_parm_id
108: WHERE expression_type = 0
109: AND EXISTS (SELECT 1
110: FROM gmd_tech_parameters_b b
111: WHERE b.tech_parm_name = a.expression_key
112: AND b.tech_parm_id = p_tech_parm_id)
113: AND EXISTS (SELECT 1
114: FROM gmd_tech_parameters_b c

Line 114: FROM gmd_tech_parameters_b c

110: FROM gmd_tech_parameters_b b
111: WHERE b.tech_parm_name = a.expression_key
112: AND b.tech_parm_id = p_tech_parm_id)
113: AND EXISTS (SELECT 1
114: FROM gmd_tech_parameters_b c
115: WHERE NVL(c.organization_id, -1) = NVL(p_orgn_id, -1)
116: AND c.tech_parm_id = a.tech_parm_id);
117:
118: /* We have parsed the expression now, lets check if their are any circular references */

Line 296: FROM gmd_tech_parameters_b

292: ) RETURN BOOLEAN IS
293:
294: CURSOR Cur_parameter (V_orgn_id NUMBER, V_parameter VARCHAR2) IS
295: SELECT tech_parm_id, data_type
296: FROM gmd_tech_parameters_b
297: WHERE tech_parm_name = V_parameter
298: AND NVL(organization_id, -1) = NVL(v_orgn_id, -1)
299: AND delete_mark = 0;
300: BEGIN