APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_SCHEDULES

Line 123: , CE_INTEREST_SCHEDULES cIS

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
127: and cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002

Line 165: , CE_INTEREST_SCHEDULES cIS

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
169: and cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002

Line 211: , CE_INTEREST_SCHEDULES CIS

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
215: CIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 459: , CE_INTEREST_SCHEDULES cIS

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
463: cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002

Line 511: , CE_INTEREST_SCHEDULES cIS

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
515: cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002

Line 568: CE_INTEREST_SCHEDULES cIS

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
572: WHERE

Line 720: , CE_INTEREST_SCHEDULES cIS

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
724: BA.BANK_ACCOUNT_ID = p_bank_account_id --10001

Line 742: , CE_INTEREST_SCHEDULES cIS

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
746: BA.BANK_ACCOUNT_ID = p_bank_account_id --10001

Line 1814: from CE_INTEREST_SCHEDULES

1810: x_interest_includes ,
1811: x_interest_rounding,
1812: x_basis,
1813: x_currency_code
1814: from CE_INTEREST_SCHEDULES
1815: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id;
1816:
1817: FND_CURRENCY.get_info(x_currency_code,
1818: precision,