APPS.GCS_DATASUB_UTILITY_PKG dependencies on FEM_CCTR_ORGS_B

Line 58: ,fem_cctr_orgs_b fcob

54: NVL(gbit.ptd_credit_balance_e, 0),
55: fb.ytd_balance_f + NVL(gbit.ptd_debit_balance_f, 0) -
56: NVL(gbit.ptd_credit_balance_f, 0)
57: FROM fem_balances fb
58: ,fem_cctr_orgs_b fcob
59: ,fem_ln_items_b flib
60: ,fem_cctr_orgs_b fcib
61: WHERE fb.ledger_id = p_ledger_id
62: AND fb.cal_period_id = p_cal_period_id

Line 60: ,fem_cctr_orgs_b fcib

56: NVL(gbit.ptd_credit_balance_f, 0)
57: FROM fem_balances fb
58: ,fem_cctr_orgs_b fcob
59: ,fem_ln_items_b flib
60: ,fem_cctr_orgs_b fcib
61: WHERE fb.ledger_id = p_ledger_id
62: AND fb.cal_period_id = p_cal_period_id
63: AND fb.dataset_code = p_dataset_code
64: AND fb.source_system_code = p_source_system_code

Line 129: ,fem_cctr_orgs_b fcob

125: gbit.ytd_credit_balance_e - NVL(fb.ytd_credit_balance_e,0) ,
126: gbit.ytd_balance_e - NVL(fb.ytd_balance_e, 0),
127: gbit.ytd_balance_f - NVL(fb.ytd_balance_f, 0)
128: FROM fem_balances fb
129: ,fem_cctr_orgs_b fcob
130: ,fem_ln_items_b flib
131: ,fem_cctr_orgs_b fcib
132: WHERE fb.ledger_id = p_ledger_id
133: AND fb.cal_period_id = p_cal_period_id

Line 131: ,fem_cctr_orgs_b fcib

127: gbit.ytd_balance_f - NVL(fb.ytd_balance_f, 0)
128: FROM fem_balances fb
129: ,fem_cctr_orgs_b fcob
130: ,fem_ln_items_b flib
131: ,fem_cctr_orgs_b fcib
132: WHERE fb.ledger_id = p_ledger_id
133: AND fb.cal_period_id = p_cal_period_id
134: AND fb.dataset_code = p_dataset_code
135: AND fb.source_system_code = p_source_system_code

Line 223: ,fem_cctr_orgs_b fcob

219: gbit.ytd_credit_balance_e - NVL(fb.ytd_credit_balance_e,0) ,
220: gbit.ytd_balance_e - NVL(fb.ytd_balance_e, 0),
221: gbit.ytd_balance_f - NVL(fb.ytd_balance_f, 0)
222: FROM fem_balances fb
223: ,fem_cctr_orgs_b fcob
224: ,fem_ln_items_b flib
225: ,fem_cctr_orgs_b fcib
226: WHERE fb.ledger_id = p_ledger_id
227: AND fb.cal_period_id = p_cal_period_id

Line 225: ,fem_cctr_orgs_b fcib

221: gbit.ytd_balance_f - NVL(fb.ytd_balance_f, 0)
222: FROM fem_balances fb
223: ,fem_cctr_orgs_b fcob
224: ,fem_ln_items_b flib
225: ,fem_cctr_orgs_b fcib
226: WHERE fb.ledger_id = p_ledger_id
227: AND fb.cal_period_id = p_cal_period_id
228: AND fb.dataset_code = p_dataset_code
229: AND fb.source_system_code = p_source_system_code

Line 349: FROM fem_cctr_orgs_b fcob

345: || DECODE ( cctr_org_display_code, NULL , l_null_err_msg ,
346: l_invalid_err_msg || '(' || cctr_org_display_code || ').' )
347: WHERE load_id = p_load_id
348: AND NOT EXISTS (SELECT 'X'
349: FROM fem_cctr_orgs_b fcob
350: WHERE fcob.cctr_org_display_code = gbit.cctr_org_display_code
351: AND fcob.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
352: ELSIF ( l_dim_id_col = 'FINANCIAL_ELEM_ID' ) THEN
353: UPDATE gcs_bal_interface_t gbit