APPS.CE_INTEREST_CALC dependencies on CE_BANK_ACCOUNTS

Line 122: --, CE_BANK_ACCOUNTS BA

118: , 'Y' FIRST_ROW
119: , rownum
120: from
121: CE_BANK_ACCT_BALANCES BAB
122: --, CE_BANK_ACCOUNTS BA
123: , CE_INTEREST_SCHEDULES cIS
124: , CE_INTEREST_BAL_RANGES IBR
125: WHERE
126: cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 164: --, CE_BANK_ACCOUNTS BA

160: , 'N' FIRST_ROW
161: , rownum
162: from
163: CE_BANK_ACCT_BALANCES BAB
164: --, CE_BANK_ACCOUNTS BA
165: , CE_INTEREST_SCHEDULES cIS
166: , CE_INTEREST_BAL_RANGES IBR
167: WHERE
168: cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 210: CE_INT_CALC_DETAILS_GT tmp2 --, CE_BANK_ACCOUNTS BA

206: , IR.BALANCE_RANGE_ID
207: , IR.INTEREST_RATE
208: from
209: --CE_BANK_ACCT_BALANCES BAB
210: CE_INT_CALC_DETAILS_GT tmp2 --, CE_BANK_ACCOUNTS BA
211: , CE_INTEREST_SCHEDULES CIS
212: , CE_INTEREST_BAL_RANGES IBR
213: , CE_INTEREST_RATES IR
214: WHERE

Line 458: --, CE_BANK_ACCOUNTS BA

454: , 'Y' FIRST_ROW
455: , rownum
456: from
457: CE_BANK_ACCT_BALANCES BAB
458: --, CE_BANK_ACCOUNTS BA
459: , CE_INTEREST_SCHEDULES cIS
460: --, CE_INTEREST_BAL_RANGES IBR
461: WHERE
462: --cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 510: --, CE_BANK_ACCOUNTS BA

506: , 'N' FIRST_ROW
507: , rownum
508: from
509: CE_BANK_ACCT_BALANCES BAB
510: --, CE_BANK_ACCOUNTS BA
511: , CE_INTEREST_SCHEDULES cIS
512: --, CE_INTEREST_BAL_RANGES IBR
513: WHERE
514: --cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 567: --, CE_BANK_ACCOUNTS BA

563: , IR.BALANCE_RANGE_ID
564: , IR.INTEREST_RATE
565: from
566: -- CE_BANK_ACCT_BALANCES BAB
567: --, CE_BANK_ACCOUNTS BA
568: CE_INTEREST_SCHEDULES cIS
569: , CE_INTEREST_BAL_RANGES IBR
570: , CE_INTEREST_RATES IR
571: , CE_INT_CALC_DETAILS_GT tmpx

Line 719: CE_BANK_ACCOUNTS BA

715: IF (p_balance_amount > 0) THEN
716: select ir.interest_rate
717: into p_interest_rate
718: from
719: CE_BANK_ACCOUNTS BA
720: , CE_INTEREST_SCHEDULES cIS
721: , CE_INTEREST_BAL_RANGES IBR
722: , CE_INTEREST_RATES IR
723: WHERE

Line 741: CE_BANK_ACCOUNTS BA

737: ELSE
738: select ir.interest_rate
739: into p_interest_rate
740: from
741: CE_BANK_ACCOUNTS BA
742: , CE_INTEREST_SCHEDULES cIS
743: , CE_INTEREST_BAL_RANGES IBR
744: , CE_INTEREST_RATES IR
745: WHERE

Line 2264: FROM CE_BANK_ACCOUNTS

2260: IF (p_bank_account_id is not null) THEN
2261: cep_standard.debug(' p_bank_account_id is not null');
2262: SELECT INTEREST_SCHEDULE_ID
2263: INTO P_INTEREST_SCHEDULE_ID
2264: FROM CE_BANK_ACCOUNTS
2265: WHERE BANK_ACCOUNT_ID = p_bank_account_id;
2266:
2267: cep_standard.debug(' p_interest_schedule_id ='||p_interest_schedule_id );
2268: