APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_INTG_DIM_HIER_C3_GT

Line 1202: INSERT INTO fem_intg_dim_hier_c3_gt

1198: 1,
1199: 'N');
1200:
1201: WHEN 3 THEN
1202: INSERT INTO fem_intg_dim_hier_c3_gt
1203: (parent_depth_num,
1204: parent_id,
1205: parent_display_code,
1206: child_depth_num,

Line 1376: INSERT INTO fem_intg_dim_hier_c3_gt

1372: AND vh.child_flex_value_high
1373: ORDER BY ff.flex_value;
1374:
1375: WHEN 3 THEN
1376: INSERT INTO fem_intg_dim_hier_c3_gt
1377: (parent_depth_num,
1378: parent_id,
1379: parent_display_code,
1380: child_depth_num,

Line 1395: FROM fem_intg_dim_hier_c3_gt gt,

1391: ff.flex_value,
1392: 'Y',
1393: -1,
1394: 'N'
1395: FROM fem_intg_dim_hier_c3_gt gt,
1396: fnd_flex_value_norm_hierarchy vh,
1397: fnd_flex_values ff
1398: WHERE gt.child_depth_num = v_parent_level
1399: AND vh.flex_value_set_id = v_aol_vs_id

Line 1591: INSERT INTO fem_intg_dim_hier_c3_gt

1587: AND ff.flex_value BETWEEN vh.child_flex_value_low AND vh.child_flex_value_high
1588: ORDER BY ff.flex_value;
1589:
1590: WHEN 3 THEN
1591: INSERT INTO fem_intg_dim_hier_c3_gt
1592: (parent_depth_num,
1593: parent_id,
1594: parent_display_code,
1595: child_depth_num,

Line 1610: FROM fem_intg_dim_hier_c3_gt gt,

1606: ff.flex_value,
1607: 'Y',
1608: -1,
1609: 'Y'
1610: FROM fem_intg_dim_hier_c3_gt gt,
1611: fnd_flex_value_norm_hierarchy vh,
1612: fnd_flex_values ff
1613: WHERE vh.flex_value_set_id = v_aol_vs_id
1614: AND vh.parent_flex_value = gt.child_display_code

Line 1860: FROM fem_intg_dim_hier_c3_gt gt

1856: INTO v_duplicate_parent
1857: FROM dual
1858: WHERE EXISTS
1859: (SELECT gt.child_display_code
1860: FROM fem_intg_dim_hier_c3_gt gt
1861: WHERE gt.parent_display_code <> gt.child_display_code
1862: GROUP BY gt.child_display_code
1863: HAVING count(gt.child_display_code) > 1);
1864: