APPS.XTR_NI_TRANSFERS_PKG dependencies on FND_LOOKUPS

Line 1163: from fnd_lookups

1159:
1160: BEGIN
1161: select count(*)
1162: into l_count
1163: from fnd_lookups
1164: where lookup_type='XTR_ROUNDING_TYPE'
1165: and lookup_code=p_rounding_type;
1166:
1167: return (l_count>0);

Line 1178: from fnd_lookups

1174:
1175: BEGIN
1176: select count(*)
1177: into l_count
1178: from fnd_lookups
1179: where lookup_type='XTR_DAY_COUNT_TYPE'
1180: and lookup_code=p_day_count_type;
1181:
1182: return (l_count>0);

Line 1193: from fnd_lookups

1189:
1190: BEGIN
1191: select count(*)
1192: into l_count
1193: from fnd_lookups
1194: where lookup_type='XTR_DAY_COUNT_BASIS'
1195: AND lookup_code IN ('30/','30E+/','30E/','ACTUAL/ACTUAL','ACTUAL360','ACTUAL365')
1196: and lookup_code=p_year_calc_type;
1197:

Line 1218: from fnd_lookups

1214:
1215: BEGIN
1216: select count(*)
1217: into l_count
1218: from fnd_lookups
1219: where lookup_type='XTR_DISCOUNT_YIELD'
1220: and lookup_code=p_basis_type;
1221:
1222: return (l_count>0);

Line 1242: from fnd_lookups

1238:
1239: BEGIN
1240: select count(*)
1241: into l_count
1242: from fnd_lookups
1243: where lookup_type='XTR_PRINCIPAL_SETTLED_BY'
1244: and lookup_code=p_client_settle;
1245:
1246: return (l_count>0);

Line 1262: fnd_lookups lu, xtr_tax_deduction_calcs c

1258: end if;
1259: select count(*)
1260: into l_count
1261: from xtr_tax_brokerage_setup a,
1262: fnd_lookups lu, xtr_tax_deduction_calcs c
1263: where a.deal_type = 'NI'
1264: and lu.lookup_type='XTR_TAX_CALC_TYPES'
1265: and lu.lookup_code=a.calc_type
1266: and a.deduction_type = 'T'

Line 1290: fnd_lookups lu, xtr_tax_deduction_calcs c

1286: end if;
1287: select count(*)
1288: into l_count
1289: from xtr_tax_brokerage_setup a,
1290: fnd_lookups lu, xtr_tax_deduction_calcs c
1291: where a.deal_type = 'NI'
1292: and lu.lookup_type='XTR_TAX_CALC_TYPES'
1293: and lu.lookup_code=a.calc_type
1294: and a.deduction_type = 'T'