APPS.FII_GL_CCID_C dependencies on FII_SLG_ASSIGNMENTS

Line 290: from fii_slg_assignments sts,

286: select DISTINCT
287: sts.chart_of_accounts_id,
288: sts.bal_seg_value,
289: sts.bal_seg_value_id
290: from fii_slg_assignments sts,
291: fii_source_ledger_groups slg
292: where slg.usage_code = 'DBI'
293: and slg.source_ledger_group_id = sts.source_ledger_group_id;
294:

Line 1018: FROM fii_slg_assignments sts,

1014: fsav1.application_column_name,
1015: fsav2.application_column_name,
1016: fsav3.application_column_name
1017: FROM ( SELECT DISTINCT sts.chart_of_accounts_id
1018: FROM fii_slg_assignments sts,
1019: fii_source_ledger_groups slg
1020: WHERE slg.usage_code = 'DBI'
1021: AND slg.source_ledger_group_id = sts.source_ledger_group_id
1022: ) coa_list,

Line 2317: -- Detect if there's changes in fii_slg_assignments

2313:
2314: ELSE
2315:
2316: ----------------------------------------------------
2317: -- Detect if there's changes in fii_slg_assignments
2318: -- table. If yes, then truncate CCID dimension and
2319: -- reset the max CCID processed to 0
2320: -----------------------------------------------------
2321: g_phase := 'Call DETECT_RELOAD';