APPS.FV_AP_CASH_POS_DTL_PKG dependencies on FV_AP_CASH_POS_TEMP

Line 70: DELETE FROM fv_ap_cash_pos_temp

66: , p_ledger_name => g_set_of_books_name);
67:
68: l_module_name := g_module_name || 'MAIN';
69:
70: DELETE FROM fv_ap_cash_pos_temp
71: WHERE checkrun_id = g_checkrun_id
72: AND set_of_books_id = g_set_of_books_id
73: AND org_id = g_org_id;
74:

Line 146: DELETE FROM fv_ap_cash_pos_temp

142: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);
143: END IF;
144: IF (retcode <> 0 AND retcode = -1) THEN
145: --changed checkrun_name to checkrun_id
146: DELETE FROM fv_ap_cash_pos_temp
147: WHERE checkrun_id = g_checkrun_id
148: AND set_of_books_id = g_set_of_books_id
149: AND org_id = g_org_id;
150: END IF;

Line 387: FROM fv_ap_cash_pos_temp

383:
384: CURSOR fund_exist_cur(p_fund VARCHAR2,p_checkrun_id NUMBER,
385: p_sob_id NUMBER,p_org_id NUMBER) IS
386: SELECT fund,gl_cash_balance
387: FROM fv_ap_cash_pos_temp
388: WHERE checkrun_id = p_checkrun_id
389: AND fund = p_fund
390: AND set_of_books_id = p_sob_id
391: AND org_id = p_org_id

Line 555: INSERT INTO fv_ap_cash_pos_temp

551: l_tot_cash_balance := l_fund_gl_balance;
552: END IF;
553: --Modified the following statement to include vendor_id ,vendor_site_id
554: --and amount formula to fix 2498036 bug.
555: INSERT INTO fv_ap_cash_pos_temp
556: (checkrun_id,
557: checkrun_name, --bug 5564904
558: check_date,
559: fund,