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.LNS_LOAN_PUB dependencies on LNS_LOOKUPS

Line 675: FROM lns_lookups llk

671: IF P_Loan_Details_Rec.loan_purpose_code IS NOT NULL THEN
672: BEGIN
673: SELECT 'Y'
674: INTO l_dummy
675: FROM lns_lookups llk
676: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_purpose_code
677: AND llk.lookup_type = 'LOAN_PURPOSE';
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN

Line 796: FROM lns_lookups llk

792: IF P_Loan_Details_Rec.loan_subtype IS NOT NULL THEN
793: BEGIN
794: SELECT 'Y'
795: INTO l_dummy
796: FROM lns_lookups llk
797: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_subtype
798: AND llk.lookup_type = 'LOAN_SUBTYPE';
799: EXCEPTION
800: WHEN NO_DATA_FOUND THEN

Line 839: FROM lns_lookups llk

835: ELSE
836: BEGIN
837: SELECT 'Y'
838: INTO l_dummy
839: FROM lns_lookups llk
840: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_term_period
841: AND llk.lookup_type = 'PERIOD';
842: EXCEPTION
843: WHEN NO_DATA_FOUND THEN

Line 917: FROM lns_lookups llk

913:
914: BEGIN
915: SELECT 'Y'
916: INTO l_dummy
917: FROM lns_lookups llk
918: WHERE llk.lookup_code = P_Loan_Details_Rec.balloon_payment_type
919: AND llk.lookup_type = 'BALLOON_PAYMENT_TYPE';
920: EXCEPTION
921: WHEN NO_DATA_FOUND THEN

Line 1182: FROM lns_lookups llk

1178: IF P_Loan_Details_Rec.RATE_TYPE IS NOT NULL THEN
1179: BEGIN
1180: SELECT 'Y'
1181: INTO l_dummy
1182: FROM lns_lookups llk
1183: WHERE llk.lookup_code = P_Loan_Details_Rec.RATE_TYPE
1184: AND llk.lookup_type = 'RATE_TYPE'
1185: AND enabled_flag = 'Y';
1186:

Line 1231: FROM lns_lookups llk

1227: IF P_Loan_Details_Rec.loan_payment_frequency IS NOT NULL THEN
1228: BEGIN
1229: SELECT 'Y'
1230: INTO l_dummy
1231: FROM lns_lookups llk
1232: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_payment_frequency
1233: AND llk.lookup_type = 'FREQUENCY';
1234: EXCEPTION
1235: WHEN NO_DATA_FOUND THEN

Line 1255: FROM lns_lookups llk

1251: IF P_Loan_Details_Rec.day_count_method IS NOT NULL THEN
1252: BEGIN
1253: SELECT 'Y'
1254: INTO l_dummy
1255: FROM lns_lookups llk
1256: WHERE llk.lookup_code = P_Loan_Details_Rec.day_count_method
1257: AND llk.lookup_type = 'DAY_COUNT_METHOD'
1258: AND enabled_flag = 'Y';
1259: EXCEPTION

Line 1282: FROM lns_lookups llk

1278: ELSE
1279: BEGIN
1280: SELECT 'Y'
1281: INTO l_dummy
1282: FROM lns_lookups llk
1283: WHERE llk.lookup_code = P_Loan_Details_Rec.PAYMENT_CALC_METHOD
1284: AND llk.lookup_type = 'PAYMENT_CALCULATION_METHOD';
1285:
1286: EXCEPTION

Line 1311: FROM lns_lookups llk

1307: IF P_Loan_Details_Rec.CALCULATION_METHOD IS NOT NULL THEN
1308: BEGIN
1309: SELECT 'Y'
1310: INTO l_dummy
1311: FROM lns_lookups llk
1312: WHERE llk.lookup_code = P_Loan_Details_Rec.CALCULATION_METHOD
1313: AND llk.lookup_type = 'INTEREST_CALCULATION_METHOD';
1314: EXCEPTION
1315: WHEN no_data_found THEN

Line 1339: FROM lns_lookups llk

1335: IF P_Loan_Details_Rec.INTEREST_COMPOUNDING_FREQ IS NOT NULL THEN
1336: BEGIN
1337: SELECT 'Y'
1338: INTO l_dummy
1339: FROM lns_lookups llk
1340: WHERE llk.lookup_code = P_Loan_Details_Rec.INTEREST_COMPOUNDING_FREQ
1341: AND llk.lookup_type = 'FREQUENCY';
1342: EXCEPTION
1343: WHEN NO_DATA_FOUND THEN

Line 1387: FROM lns_lookups llk

1383: ELSE
1384: BEGIN
1385: SELECT 'Y'
1386: INTO l_dummy
1387: FROM lns_lookups llk
1388: WHERE llk.lookup_code = P_Loan_Details_Rec.CUSTOM_CALC_METHOD
1389: AND llk.lookup_type = 'CUSTOM_CALCULATION_METHOD';
1390:
1391: EXCEPTION

Line 1408: FROM lns_lookups llk

1404: ELSE
1405: BEGIN
1406: SELECT 'Y'
1407: INTO l_dummy
1408: FROM lns_lookups llk
1409: WHERE llk.lookup_code = P_Loan_Details_Rec.ORIG_PAY_CALC_METHOD
1410: AND llk.lookup_type = 'PAYMENT_CALCULATION_METHOD';
1411:
1412: EXCEPTION

Line 1535: FROM lns_lookups llk

1531: ELSE
1532: BEGIN
1533: SELECT 'Y'
1534: INTO l_dummy
1535: FROM lns_lookups llk
1536: WHERE llk.lookup_code = P_Loan_Details_Rec.open_loan_term_period
1537: AND llk.lookup_type = 'PERIOD';
1538: EXCEPTION
1539: WHEN NO_DATA_FOUND THEN

Line 1616: FROM lns_lookups llk

1612: IF P_Loan_Details_Rec.open_to_term_event IS NOT NULL THEN
1613: BEGIN
1614: SELECT 'Y'
1615: INTO l_dummy
1616: FROM lns_lookups llk
1617: WHERE llk.lookup_code = P_Loan_Details_Rec.open_to_term_event
1618: AND llk.lookup_type = 'OPEN_TO_TERM_EVENT';
1619: EXCEPTION
1620: WHEN NO_DATA_FOUND THEN

Line 1753: FROM lns_lookups llk

1749: ELSE
1750: BEGIN
1751: SELECT 'Y'
1752: INTO l_dummy
1753: FROM lns_lookups llk
1754: WHERE llk.lookup_code = P_Loan_Details_Rec.PRIN_PAYMENT_FREQUENCY
1755: AND llk.lookup_type = 'FREQUENCY';
1756:
1757: EXCEPTION

Line 1803: FROM lns_lookups llk

1799: IF P_Loan_Details_Rec.REAMORTIZE_ON_FUNDING IS NOT NULL THEN
1800: BEGIN
1801: SELECT 'Y'
1802: INTO l_dummy
1803: FROM lns_lookups llk
1804: WHERE llk.lookup_code = P_Loan_Details_Rec.REAMORTIZE_ON_FUNDING
1805: AND llk.lookup_type = 'REAMORTIZE_ON_FUNDING_OPTIONS';
1806: EXCEPTION
1807: WHEN NO_DATA_FOUND THEN

Line 1906: FROM lns_lookups llk

1902: ELSE
1903: BEGIN
1904: SELECT 'Y'
1905: INTO l_dummy
1906: FROM lns_lookups llk
1907: WHERE llk.lookup_code = p_loan_part_tbl(l_count).loan_participant_type
1908: AND llk.lookup_type = 'LNS_PARTICIPANT_TYPE'
1909: AND enabled_flag = 'Y'
1910: AND lookup_code <> 'PRIMARY_BORROWER';