APPS.FV_GTAS_INTERFACE dependencies on FV_GTAS_ENDING_BALANCES

Line 347: FROM fv_gtas_ending_balances

343: --and there are no errors
344: IF (gbl_error_code = 0 AND p_save_ending_Bal = 'Y' ) then
345: SELECT count(*)
346: Into L_Row_Exists
347: FROM fv_gtas_ending_balances
348: WHERE fiscal_year = gbl_period_year
349: AND set_of_books_id = gbl_set_of_books_id
350: AND rownum = 1;
351:

Line 356: DELETE FROM fv_gtas_ending_balances

352: IF (l_row_exists > 0) THEN
353: log(l_module_name, 'Deleting recs from fv_gtas_ending_bal
354: for Period Year: '||gbl_period_year);
355:
356: DELETE FROM fv_gtas_ending_balances
357: WHERE set_of_books_id = gbl_set_of_books_id
358: AND fiscal_year = gbl_period_year;
359: log(l_module_name, 'Deleted '||SQL%ROWCOUNT ||
360: ' recs from fv_gtas_ending_balances.');

Line 360: ' recs from fv_gtas_ending_balances.');

356: DELETE FROM fv_gtas_ending_balances
357: WHERE set_of_books_id = gbl_set_of_books_id
358: AND fiscal_year = gbl_period_year;
359: log(l_module_name, 'Deleted '||SQL%ROWCOUNT ||
360: ' recs from fv_gtas_ending_balances.');
361: COMMIT;
362: END IF;
363:
364: create_end_bal_record;

Line 1691: Insert Into Fv_Gtas_Ending_Balances

1687: --Using the view to insert ending balances
1688: --'P' is prior year end balance
1689: --'L' is current year activity
1690: --Both together are curr year end bal
1691: Insert Into Fv_Gtas_Ending_Balances
1692: (Ccid,
1693: Set_Of_Books_Id,
1694: Fund_Value,
1695: Account_Number,

Line 2392: FROM fv_gtas_ending_balances

2388: l_stage := 'Ending balance diff';
2389:
2390: SELECT NVL(SUM(amount), 0)
2391: Into L_Ending_Amount
2392: FROM fv_gtas_ending_balances
2393: WHERE ccid = l_ccid_l(i)
2394: AND set_of_books_id = gbl_set_of_books_id
2395: AND fiscal_year = (gbl_fiscal_year - 1)
2396: AND record_category = 'ENDING_BAL'