APPS.XTR_WRAPPER_API_P dependencies on XTR_INTEREST_RATE_RANGES_V

Line 1323: from xtr_INTEREST_RATE_RANGES_v

1319: p_warn_message OUT NOCOPY VARCHAR2) is
1320: --
1321: cursor FIND_SPECIFIC_RATE is
1322: select INTEREST_RATE
1323: from xtr_INTEREST_RATE_RANGES_v
1324: where PARTY_CODE = p_party_code
1325: and CURRENCY = nvl(p_currency,CURRENCY)
1326: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1327: and MIN_AMT < to_number(p_balance_out)

Line 1330: from xtr_INTEREST_RATE_RANGES_v

1326: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1327: and MIN_AMT < to_number(p_balance_out)
1328: and MAX_AMT >= to_number(p_balance_out)
1329: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1330: from xtr_INTEREST_RATE_RANGES_v
1331: where PARTY_CODE = p_PARTY_CODE
1332: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1333: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1334: and MIN_AMT < to_number(p_BALANCE_OUT)

Line 1340: from xtr_INTEREST_RATE_RANGES_v

1336: and EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE );
1337:
1338: cursor FIND_GLOBAL_RATE is
1339: select INTEREST_RATE
1340: from xtr_INTEREST_RATE_RANGES_v
1341: where PARTY_CODE = p_COMPANY_CODE
1342: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1343: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1344: and MIN_AMT < p_BALANCE_OUT

Line 1347: from xtr_INTEREST_RATE_RANGES_v

1343: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1344: and MIN_AMT < p_BALANCE_OUT
1345: and MAX_AMT >= p_BALANCE_OUT
1346: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1347: from xtr_INTEREST_RATE_RANGES_v
1348: where EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE
1349: and PARTY_CODE = p_COMPANY_CODE
1350: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1351: and REF_CODE = p_ref_code -- 'IG_PRO1075'

Line 1358: from xtr_INTEREST_RATE_RANGES_v

1354: --
1355: --
1356: cursor DR_RANGE(p_party varchar2) is
1357: select nvl(INTEREST_RATE,0)
1358: from xtr_INTEREST_RATE_RANGES_v
1359: where PARTY_CODE = p_party
1360: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1361: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1362: and MAX_AMT >= p_BALANCE_OUT

Line 1366: from xtr_INTEREST_RATE_RANGES_v

1362: and MAX_AMT >= p_BALANCE_OUT
1363: and MIN_AMT <= 0
1364: and MIN_AMT < 0
1365: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1366: from xtr_INTEREST_RATE_RANGES_v
1367: where EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE
1368: and PARTY_CODE = p_party
1369: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1370: and REF_CODE = p_ref_code -- 'IG_PRO1075'

Line 1379: from xtr_INTEREST_RATE_RANGES_v

1375: --
1376:
1377: cursor CR_RANGE(p_party varchar2) is
1378: select nvl(INTEREST_RATE,0)
1379: from xtr_INTEREST_RATE_RANGES_v
1380: where PARTY_CODE = p_party
1381: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1382: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1383: and MIN_AMT <= p_BALANCE_OUT

Line 1387: from xtr_INTEREST_RATE_RANGES_v

1383: and MIN_AMT <= p_BALANCE_OUT
1384: and MAX_AMT >= 0
1385: and MIN_AMT >= 0
1386: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1387: from xtr_INTEREST_RATE_RANGES_v
1388: where EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE
1389: and PARTY_CODE = p_party
1390: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1391: and REF_CODE = p_ref_code -- 'IG_PRO1075'