APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on XTR_BANK_BAL_INTERFACE

Line 247: from XTR_BANK_BAL_INTERFACE

243: and PARTY_CODE = new_company;
244: --
245: cursor NEW_BALANCE is
246: select rtrim(ACCOUNT_NO,' '),trunc(BALANCE_DATE), AMOUNT, AMOUNT_ADJ, AMOUNT_CFLOW, COMPANY_CODE, ONE_DAY_FLOAT, TWO_DAY_FLOAT
247: from XTR_BANK_BAL_INTERFACE
248: where TRANSFER_SUCCEEDED is null;
249: --
250: cursor PREV_DETAILS is
251: select a.BALANCE_DATE,a.BALANCE_CFLOW,a.ACCUM_INT_CFWD,a.INTEREST_RATE,a.accrual_interest,

Line 422: update XTR_BANK_BAL_INTERFACE

418: l_rounding_type, l_day_count_type, l_original_amount, l_one_day_float, l_two_day_float); -- Added for Interest Override
419:
420: new_bal_hce := round(new_bal / l_hc_rate,roundfac);
421: --
422: update XTR_BANK_BAL_INTERFACE
423: set TRANSFER_SUCCEEDED = 'Y'
424: where ACCOUNT_NO = acct_no
425: and COMPANY_CODE = new_company
426: and BALANCE_DATE = new_date;

Line 443: update XTR_BANK_BAL_INTERFACE

439: );
440: else
441: close CHK_EXISTING_DATE;
442: --
443: update XTR_BANK_BAL_INTERFACE
444: set TRANSFER_SUCCEEDED = 'N'
445: where ACCOUNT_NO = acct_no
446: and COMPANY_CODE = new_company
447: and BALANCE_DATE = new_date;

Line 450: update XTR_BANK_BAL_INTERFACE

446: and COMPANY_CODE = new_company
447: and BALANCE_DATE = new_date;
448: end if;
449: else
450: update XTR_BANK_BAL_INTERFACE
451: set TRANSFER_SUCCEEDED = 'N'
452: where ACCOUNT_NO = acct_no
453: and COMPANY_CODE = new_company
454: and BALANCE_DATE = new_date;