APPS.LNS_LOAN_PUB dependencies on LNS_LOOKUPS

Line 632: FROM lns_lookups llk

628: IF P_Loan_Details_Rec.loan_purpose_code IS NOT NULL THEN
629: BEGIN
630: SELECT 'Y'
631: INTO l_dummy
632: FROM lns_lookups llk
633: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_purpose_code
634: AND llk.lookup_type = 'LOAN_PURPOSE';
635: EXCEPTION
636: WHEN NO_DATA_FOUND THEN

Line 761: FROM lns_lookups llk

757: AND l_override_rec.loan_term_period_ovr = 'Y' THEN
758: BEGIN
759: SELECT 'Y'
760: INTO l_dummy
761: FROM lns_lookups llk
762: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_term_period
763: AND llk.lookup_type = 'PERIOD';
764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN

Line 834: FROM lns_lookups llk

830: AND l_product_rec.multiple_funding_flag = 'Y' THEN
831: BEGIN
832: SELECT 'Y'
833: INTO l_dummy
834: FROM lns_lookups llk
835: WHERE llk.lookup_code = P_Loan_Details_Rec.open_loan_term_period
836: AND llk.lookup_type = 'PERIOD';
837: EXCEPTION
838: WHEN NO_DATA_FOUND THEN

Line 852: FROM lns_lookups llk

848: l_product_rec.open_to_term_flag = 'Y')) THEN
849: BEGIN
850: SELECT 'Y'
851: INTO l_dummy
852: FROM lns_lookups llk
853: WHERE llk.lookup_code = P_Loan_Details_Rec.balloon_payment_type
854: AND llk.lookup_type = 'BALLOON_PAYMENT_TYPE';
855: EXCEPTION
856: WHEN NO_DATA_FOUND THEN

Line 908: FROM lns_lookups llk

904: AND l_override_rec.loan_subtype_ovr = 'Y' THEN
905: BEGIN
906: SELECT 'Y'
907: INTO l_dummy
908: FROM lns_lookups llk
909: WHERE llk.lookup_code = P_Loan_Details_Rec.loan_subtype
910: AND llk.lookup_type = 'LOAN_SUBTYPE';
911: EXCEPTION
912: WHEN NO_DATA_FOUND THEN

Line 956: FROM lns_lookups llk

952: AND l_override_rec.loan_payment_freq_ovr = 'Y' THEN
953: BEGIN
954: SELECT 'Y'
955: INTO l_dummy
956: FROM lns_lookups llk
957: WHERE llk.lookup_code =
958: P_Loan_Details_Rec.loan_payment_frequency
959: AND llk.lookup_type = 'FREQUENCY';
960: EXCEPTION

Line 974: FROM lns_lookups llk

970: AND l_product_rec.multiple_funding_flag = 'Y' THEN
971: BEGIN
972: SELECT 'Y'
973: INTO l_dummy
974: FROM lns_lookups llk
975: WHERE llk.lookup_code = P_Loan_Details_Rec.open_to_term_event
976: AND llk.lookup_type = 'OPEN_TO_TERM_EVENT';
977: EXCEPTION
978: WHEN NO_DATA_FOUND THEN