APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_INTG_DIM_HIER_C1_GT

Line 1158: INSERT INTO fem_intg_dim_hier_c1_gt

1154:
1155:
1156: CASE pv_traversal_rarray(i_hier_ctr).display_order
1157: WHEN 1 THEN
1158: INSERT INTO fem_intg_dim_hier_c1_gt
1159: (parent_depth_num,
1160: parent_id,
1161: parent_display_code,
1162: child_depth_num,

Line 1308: INSERT INTO fem_intg_dim_hier_c1_gt

1304: ' v_parent_level:' || v_parent_level);
1305:
1306: CASE pv_traversal_rarray(i_hier_ctr).display_order
1307: WHEN 1 THEN
1308: INSERT INTO fem_intg_dim_hier_c1_gt
1309: (parent_depth_num,
1310: parent_id,
1311: parent_display_code,
1312: child_depth_num,

Line 1327: FROM fem_intg_dim_hier_c1_gt gt,

1323: ff.flex_value,
1324: 'Y',
1325: -1,
1326: 'N'
1327: FROM fem_intg_dim_hier_c1_gt gt,
1328: fnd_flex_value_norm_hierarchy vh,
1329: fnd_flex_values ff
1330: WHERE gt.child_depth_num = v_parent_level
1331: AND vh.flex_value_set_id = v_aol_vs_id

Line 1529: INSERT INTO fem_intg_dim_hier_c1_gt

1525: ' traversal hierarchy_obj_def_id:' || pv_traversal_rarray(i_hier_ctr).display_order);
1526:
1527: CASE pv_traversal_rarray(i_hier_ctr).display_order
1528: WHEN 1 THEN
1529: INSERT INTO fem_intg_dim_hier_c1_gt
1530: (parent_depth_num,
1531: parent_id,
1532: parent_display_code,
1533: child_depth_num,

Line 1548: FROM fem_intg_dim_hier_c1_gt gt,

1544: ff.flex_value,
1545: 'Y',
1546: -1,
1547: 'Y'
1548: FROM fem_intg_dim_hier_c1_gt gt,
1549: fnd_flex_value_norm_hierarchy vh,
1550: fnd_flex_values ff
1551: WHERE vh.flex_value_set_id = v_aol_vs_id
1552: AND vh.parent_flex_value = gt.child_display_code

Line 1838: FROM fem_intg_dim_hier_c1_gt gt

1834: INTO v_duplicate_parent
1835: FROM dual
1836: WHERE EXISTS
1837: (SELECT gt.child_display_code
1838: FROM fem_intg_dim_hier_c1_gt gt
1839: WHERE gt.parent_display_code <> gt.child_display_code
1840: GROUP BY gt.child_display_code
1841: HAVING count(gt.child_display_code) > 1);
1842: