APPS.GCS_DATASUB_UTILITY_PKG dependencies on FEM_BALANCES

Line 57: FROM fem_balances fb

53: fb.ytd_balance_e + NVL(gbit.ptd_debit_balance_e, 0) -
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

Line 128: FROM fem_balances fb

124: SELECT gbit.ytd_debit_balance_e - NVL(fb.ytd_debit_balance_e,0) ,
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

Line 222: FROM fem_balances fb

218: SELECT gbit.ytd_debit_balance_e - NVL(fb.ytd_debit_balance_e,0) ,
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