DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 2714: vl_checkrun_name Ap_Inv_Selection_Criteria_All.checkrun_name%TYPE;

2710: l_cursor_id INTEGER;
2711: l_ignore INTEGER;
2712: l_select VARCHAR2(2000);
2713:
2714: vl_checkrun_name Ap_Inv_Selection_Criteria_All.checkrun_name%TYPE;
2715: vl_treasury_symbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
2716: vl_misc_cd_flag VARCHAR2(1);
2717: vl_refund_cnt NUMBER:= 0;
2718:

Line 3807: FROM Ap_Inv_Selection_Criteria_All

3803: IF (vl_checkrun_name IS NOT NULL) THEN -- vl_checkrun
3804: BEGIN
3805: SELECT ce_bank_acct_use_id
3806: INTO vg_bank_acct_id
3807: FROM Ap_Inv_Selection_Criteria_All
3808: WHERE checkrun_name = vl_checkrun_name
3809: AND org_id = l_org_id;
3810: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 3825: 'bank_account_id from Ap_Inv_Selection_Criteria_All table.';

3821: Set_Exception('D');
3822: GOTO end_label;
3823: WHEN OTHERS THEN
3824: error_buf := SQLERRM||'- Error while deriving the '||
3825: 'bank_account_id from Ap_Inv_Selection_Criteria_All table.';
3826: error_code := 2;
3827: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error17', error_buf) ;
3828: RETURN;
3829: END;