APPS.IBY_FACTOR_PKG dependencies on FND_LOOKUP_VALUES

Line 100: from FND_LOOKUP_VALUES

96: l_payeeid varchar2(80);
97:
98: cursor c_load_factor is
99: select meaning, description
100: from FND_LOOKUP_VALUES
101: where
102: lookup_code = 'PMTAMOUNT' and
103: lookup_type = 'IBY_RISK_FACTOR_NAME' and
104: language = userenv('LANG');

Line 272: from FND_LOOKUP_VALUES

268: l_payeeid varchar2(80);
269:
270: cursor c_load_factor is
271: select meaning, description
272: from FND_LOOKUP_VALUES
273: where
274: lookup_code = 'TIMEOFPURCHASE' and
275: lookup_type = 'IBY_RISK_FACTOR_NAME' and
276: language = userenv('LANG');

Line 431: from FND_LOOKUP_VALUES

427: l_payeeid varchar2(80);
428:
429: cursor c_load_factor is
430: select meaning, description
431: from FND_LOOKUP_VALUES
432: where
433: lookup_code = 'TRXNAMOUNT' and
434: lookup_type = 'IBY_RISK_FACTOR_NAME' and
435: language = userenv('LANG');

Line 643: from FND_LOOKUP_VALUES

639: l_payeeid varchar2(80);
640:
641: cursor c_load_factor is
642: select meaning, description
643: from FND_LOOKUP_VALUES
644: where
645: lookup_code = 'PMTHISTORY' and
646: lookup_type = 'IBY_RISK_FACTOR_NAME' and
647: language = userenv('LANG');

Line 812: from FND_LOOKUP_VALUES

808: l_payeeid varchar2(80);
809:
810: cursor c_load_factor is
811: select meaning, description
812: from FND_LOOKUP_VALUES
813: where
814: lookup_code = 'AVSCODES' and
815: lookup_type = 'IBY_RISK_FACTOR_NAME' and
816: language = userenv('LANG');

Line 962: from FND_LOOKUP_VALUES

958: l_payeeid varchar2(80);
959:
960: cursor c_load_factor is
961: select meaning, description
962: from FND_LOOKUP_VALUES
963: where
964: lookup_code = 'RISKCODES' and
965: lookup_type = 'IBY_RISK_FACTOR_NAME' and
966: language = userenv('LANG');

Line 979: from fnd_lookup_values

975: where mapping_type = 'RISK_CODE_TYPE' and
976: payeeid = ci_payeeid
977: UNION
978: select lookup_code,null
979: from fnd_lookup_values
980: where lookup_type = 'RISK_CODE' and
981: enabled_flag = 'Y' and
982: language = userenv('LANG') and
983:

Line 996: fnd_lookup_values

992:
993: cursor c_risk_codes2 is
994: select lookup_code
995: from
996: fnd_lookup_values
997: where
998: lookup_type = 'RISK_CODE' and
999: enabled_flag = 'Y' and
1000: language = userenv('LANG');

Line 1010: fnd_lookup_values b

1006:
1007: cursor c_del_risk_codes is
1008: select lookup_code
1009: from iby_mappings a,
1010: fnd_lookup_values b
1011: where b.lookup_type = 'RISK_CODE' and
1012: b.enabled_flag = 'N' and
1013: b.lookup_code = a.mapping_code and
1014: b.language = userenv('LANG');

Line 1170: from FND_LOOKUP_VALUES

1166:
1167:
1168: cursor c_load_factor is
1169: select meaning, description
1170: from FND_LOOKUP_VALUES
1171: where
1172: lookup_code = 'CREDITRATINGCODES' and
1173: lookup_type = 'IBY_RISK_FACTOR_NAME' and
1174: language = userenv('LANG');

Line 1187: from fnd_lookup_values

1183: where mapping_type = 'CREDIT_CODE_TYPE' and
1184: payeeid = ci_payeeid
1185: UNION
1186: select lookup_code,null
1187: from fnd_lookup_values
1188: where lookup_type = 'CREDIT_RATING' and
1189: enabled_flag = 'Y' and
1190: language = userenv('LANG') and
1191:

Line 1204: fnd_lookup_values

1200:
1201: cursor c_creditrating_codes2 is
1202: select lookup_code
1203: from
1204: fnd_lookup_values
1205: where
1206: lookup_type = 'CREDIT_RATING' and
1207: enabled_flag = 'Y' and
1208: language = userenv('LANG');

Line 1216: fnd_lookup_values b

1212:
1213: cursor c_del_creditrating_codes is
1214: select lookup_code
1215: from iby_mappings a,
1216: fnd_lookup_values b
1217: where b.lookup_type = 'CREDIT_RATING' and
1218: b.enabled_flag = 'N' and
1219: b.lookup_code = a.mapping_code and
1220: b.language = userenv('LANG');

Line 1369: from FND_LOOKUP_VALUES

1365: l_cnt integer;
1366:
1367: cursor c_load_factor is
1368: select meaning, description
1369: from FND_LOOKUP_VALUES
1370: where
1371: lookup_code = 'FREQOFPURCHASE' and
1372: lookup_type = 'IBY_RISK_FACTOR_NAME' and
1373: language = userenv('LANG');