eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_WRAPPER_API_P dependencies on XTR_INTEREST_RATE_RANGES_V

Line 1089: from xtr_INTEREST_RATE_RANGES_v

1085: p_warn_message OUT NOCOPY VARCHAR2) is
1086: --
1087: cursor FIND_SPECIFIC_RATE is
1088: select INTEREST_RATE
1089: from xtr_INTEREST_RATE_RANGES_v
1090: where PARTY_CODE = p_party_code
1091: and CURRENCY = nvl(p_currency,CURRENCY)
1092: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1093: and MIN_AMT < to_number(p_balance_out)

Line 1096: from xtr_INTEREST_RATE_RANGES_v

1092: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1093: and MIN_AMT < to_number(p_balance_out)
1094: and MAX_AMT >= to_number(p_balance_out)
1095: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1096: from xtr_INTEREST_RATE_RANGES_v
1097: where PARTY_CODE = p_PARTY_CODE
1098: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1099: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1100: and MIN_AMT < to_number(p_BALANCE_OUT)

Line 1106: from xtr_INTEREST_RATE_RANGES_v

1102: and EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE );
1103:
1104: cursor FIND_GLOBAL_RATE is
1105: select INTEREST_RATE
1106: from xtr_INTEREST_RATE_RANGES_v
1107: where PARTY_CODE = p_COMPANY_CODE
1108: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1109: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1110: and MIN_AMT < p_BALANCE_OUT

Line 1113: from xtr_INTEREST_RATE_RANGES_v

1109: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1110: and MIN_AMT < p_BALANCE_OUT
1111: and MAX_AMT >= p_BALANCE_OUT
1112: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1113: from xtr_INTEREST_RATE_RANGES_v
1114: where EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE
1115: and PARTY_CODE = p_COMPANY_CODE
1116: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1117: and REF_CODE = p_ref_code -- 'IG_PRO1075'

Line 1124: from xtr_INTEREST_RATE_RANGES_v

1120: --
1121: --
1122: cursor DR_RANGE(p_party varchar2) is
1123: select nvl(INTEREST_RATE,0)
1124: from xtr_INTEREST_RATE_RANGES_v
1125: where PARTY_CODE = p_party
1126: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1127: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1128: and MAX_AMT >= p_BALANCE_OUT

Line 1132: from xtr_INTEREST_RATE_RANGES_v

1128: and MAX_AMT >= p_BALANCE_OUT
1129: and MIN_AMT <= 0
1130: and MIN_AMT < 0
1131: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1132: from xtr_INTEREST_RATE_RANGES_v
1133: where EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE
1134: and PARTY_CODE = p_party
1135: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1136: and REF_CODE = p_ref_code -- 'IG_PRO1075'

Line 1145: from xtr_INTEREST_RATE_RANGES_v

1141: --
1142:
1143: cursor CR_RANGE(p_party varchar2) is
1144: select nvl(INTEREST_RATE,0)
1145: from xtr_INTEREST_RATE_RANGES_v
1146: where PARTY_CODE = p_party
1147: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1148: and REF_CODE = p_ref_code -- 'IG_PRO1075'
1149: and MIN_AMT <= p_BALANCE_OUT

Line 1153: from xtr_INTEREST_RATE_RANGES_v

1149: and MIN_AMT <= p_BALANCE_OUT
1150: and MAX_AMT >= 0
1151: and MIN_AMT >= 0
1152: and EFFECTIVE_FROM_DATE = (select max(EFFECTIVE_FROM_DATE)
1153: from xtr_INTEREST_RATE_RANGES_v
1154: where EFFECTIVE_FROM_DATE <= p_TRANSFER_DATE
1155: and PARTY_CODE = p_party
1156: and CURRENCY = nvl(p_CURRENCY,CURRENCY)
1157: and REF_CODE = p_ref_code -- 'IG_PRO1075'