APPS.GCS_DATASUB_UTILITY_PKG dependencies on FEM_LN_ITEMS_B

Line 59: ,fem_ln_items_b flib

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
63: AND fb.dataset_code = p_dataset_code

Line 130: ,fem_ln_items_b flib

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
134: AND fb.dataset_code = p_dataset_code

Line 224: ,fem_ln_items_b flib

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
228: AND fb.dataset_code = p_dataset_code

Line 243: FROM fem_ln_items_b flib,

239: AND fcib.cctr_org_display_code = gbit.intercompany_display_code
240: )
241: WHERE gbit.load_id = p_load_id
242: AND EXISTS (SELECT 'X'
243: FROM fem_ln_items_b flib,
244: fem_ln_items_attr flia,
245: fem_ext_acct_types_attr fea_attr
246: WHERE gbit.line_item_display_code = flib.line_item_display_code
247: AND flib.line_item_id = flia.line_item_id

Line 369: FROM fem_ln_items_b flib

365: || DECODE ( line_item_display_code, NULL , l_null_err_msg ,
366: l_invalid_err_msg || '(' || line_item_display_code || ').' )
367: WHERE load_id = p_load_id
368: AND NOT EXISTS (SELECT 'X'
369: FROM fem_ln_items_b flib
370: WHERE flib.line_item_display_code = gbit.line_item_display_code
371: AND flib.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
372: ELSIF ( l_dim_id_col = 'PRODUCT_ID') THEN
373: UPDATE gcs_bal_interface_t gbit