APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG dependencies on FEM_GLOBAL_VS_COMBOS_B

Line 1302: ' (SELECT 1 FROM fem_global_vs_combos_b g '||

1298: l_count :=0 ;
1299: l_validation_sql:= ' SELECT B.rowid '||
1300: ' FROM '||v_member_table_name||' B'||
1301: ' WHERE not exists '||
1302: ' (SELECT 1 FROM fem_global_vs_combos_b g '||
1303: ' WHERE B.global_vs_combo_display_code= g.global_vs_combo_display_code)'||
1304: ' AND B.status = ''LOAD'''||
1305: -- ' AND 1=1';
1306: ' AND '||v_data_slc;

Line 1529: ' ,fem_global_vs_combos_b g'||

1525: ' WHERE NOT EXISTS ('||
1526: ' SELECT 1'||
1527: ' FROM fem_ledgers_b l'||
1528: ' ,fem_ledgers_attr a'||
1529: ' ,fem_global_vs_combos_b g'||
1530: ' WHERE l.ledger_display_code = b.ledger_display_code'||
1531: ' AND a.ledger_id = l.ledger_id'||
1532: ' AND a.attribute_id = '||c_attr.attribute_id||
1533: ' AND a.version_id = '||c_attr.version_id||

Line 1870: FEM_GLOBAL_VS_COMBOS_b m

1866: SELECT g.dimension_id
1867: ,g.value_set_id
1868: ,g.global_vs_combo_id
1869: FROM FEM_GLOBAL_VS_COMBO_DEFS g,
1870: FEM_GLOBAL_VS_COMBOS_b m
1871: WHERE g.global_vs_combo_id = m.global_vs_combo_id
1872: AND g.dimension_id = t_metadata(i).dimension_id
1873: AND m.global_vs_combo_display_code = t_global_vs_combo_dc(j)
1874: ORDER BY 1)