APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on XTR_INTEREST_RATE_RANGES

Line 41: from XTR_INTEREST_RATE_RANGES

37: and CURRENCY = L_CURRENCY;
38: --
39: cursor FLAT_RATE is
40: select INTEREST_RATE
41: from XTR_INTEREST_RATE_RANGES
42: where REF_CODE = l_acct
43: and PARTY_CODE = l_bank_code
44: -- and PARTY_CODE = l_setoff_party
45: and CURRENCY = L_CURRENCY

Line 49: from XTR_INTEREST_RATE_RANGES

45: and CURRENCY = L_CURRENCY
46: and MIN_AMT < l_balance
47: and MAX_AMT >= l_balance
48: and EFFECTIVE_FROM_DATE =(select max(EFFECTIVE_FROM_DATE)
49: from XTR_INTEREST_RATE_RANGES
50: where REF_CODE = l_acct
51: and PARTY_CODE = l_bank_code
52: --and PARTY_CODE = l_setoff_party
53: and CURRENCY = L_CURRENCY

Line 60: from XTR_INTEREST_RATE_RANGES

56: and EFFECTIVE_FROM_DATE<= L_BALANCE_DATE);
57: --
58: cursor DR_RANGE is
59: select MIN_AMT,MAX_AMT,nvl(INTEREST_RATE,0)
60: from XTR_INTEREST_RATE_RANGES
61: where REF_CODE = l_acct
62: and PARTY_CODE = l_bank_code
63: -- and PARTY_CODE = l_setoff_party
64: and CURRENCY = L_CURRENCY

Line 68: from XTR_INTEREST_RATE_RANGES

64: and CURRENCY = L_CURRENCY
65: and MAX_AMT >= l_amount
66: and MIN_AMT <0
67: and EFFECTIVE_FROM_DATE =(select max(EFFECTIVE_FROM_DATE)
68: from XTR_INTEREST_RATE_RANGES
69: where REF_CODE = l_acct
70: and PARTY_CODE = l_bank_code
71: --and PARTY_CODE = l_setoff_party
72: and CURRENCY = L_CURRENCY

Line 81: from XTR_INTEREST_RATE_RANGES

77: --
78:
79: cursor CR_RANGE is
80: select MIN_AMT,MAX_AMT,nvl(INTEREST_RATE,0)
81: from XTR_INTEREST_RATE_RANGES
82: where REF_CODE = l_acct
83: and PARTY_CODE = l_bank_code
84: -- and PARTY_CODE = l_setoff_party
85: and CURRENCY = L_CURRENCY

Line 89: from XTR_INTEREST_RATE_RANGES

85: and CURRENCY = L_CURRENCY
86: and MIN_AMT <= l_amount
87: and MAX_AMT >= 0
88: and EFFECTIVE_FROM_DATE =(select max(EFFECTIVE_FROM_DATE)
89: from XTR_INTEREST_RATE_RANGES
90: where REF_CODE = l_acct
91: and PARTY_CODE = l_bank_code
92: -- and PARTY_CODE = l_setoff_party
93: and CURRENCY = L_CURRENCY