APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on DUAL

Line 284: null) INTO l_rec.aol_vs_id FROM DUAL;

280: v_app_col_name2, v_aol_vs_id2,
281: v_app_col_name3, v_aol_vs_id3,
282: v_app_col_name4, v_aol_vs_id4,
283: v_app_col_name5, v_aol_vs_id5,
284: null) INTO l_rec.aol_vs_id FROM DUAL;
285: -- Using application_column_name to get dimension segment concatenation order
286: SELECT decode(v_traversal_info.application_column_name,
287: v_app_col_name1, 1,
288: v_app_col_name2, 2,

Line 292: null) INTO l_rec.concat_segment FROM DUAL;

288: v_app_col_name2, 2,
289: v_app_col_name3, 3,
290: v_app_col_name4, 4,
291: v_app_col_name5, 5,
292: null) INTO l_rec.concat_segment FROM DUAL;
293: -- Using l_rec.aol_vs_id and l_rec.top_parent_value to get l_rec.top_parent_id
294: select flex_value_id into l_rec.top_parent_id
295: from fnd_flex_values
296: where flex_value_set_id=l_rec.aol_vs_id

Line 1835: FROM dual

1831:
1832: WHEN 1 THEN
1833: SELECT 'Duplicate'
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

Line 1846: FROM dual

1842:
1843: WHEN 2 THEN
1844: SELECT 'Duplicate'
1845: INTO v_duplicate_parent
1846: FROM dual
1847: WHERE EXISTS
1848: (SELECT gt.child_display_code
1849: FROM fem_intg_dim_hier_c2_gt gt
1850: WHERE gt.parent_display_code <> gt.child_display_code

Line 1857: FROM dual

1853:
1854: WHEN 3 THEN
1855: SELECT 'Duplicate'
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

Line 1868: FROM dual

1864:
1865: WHEN 4 THEN
1866: SELECT 'Duplicate'
1867: INTO v_duplicate_parent
1868: FROM dual
1869: WHERE EXISTS
1870: (SELECT gt.child_display_code
1871: FROM fem_intg_dim_hier_c4_gt gt
1872: WHERE gt.parent_display_code <> gt.child_display_code

Line 1879: FROM dual

1875:
1876: WHEN 5 THEN
1877: SELECT 'Duplicate'
1878: INTO v_duplicate_parent
1879: FROM dual
1880: WHERE EXISTS
1881: (SELECT gt.child_display_code
1882: FROM fem_intg_dim_hier_c5_gt gt
1883: WHERE gt.parent_display_code <> gt.child_display_code

Line 3021: FROM dual

3017: IF (pv_dim_mapping_option_code = 'SINGLESEG') THEN
3018: BEGIN
3019: SELECT 'Duplicate'
3020: INTO v_duplicate_parent
3021: FROM dual
3022: WHERE EXISTS
3023: (SELECT gt.child_id
3024: FROM fem_intg_dim_hier_gt gt
3025: WHERE gt.parent_id <> gt.child_id