APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_TYPES

Line 1052: ,lns_loan_types t

1048: ,t.loan_type_id
1049: -- ,h.funded_amount
1050: ,h.requested_amount -- Bug#9755933
1051: from lns_loan_headers_all h
1052: ,lns_loan_types t
1053: where h.loan_id = p_loan_id
1054: and h.loan_type_id = t.loan_type_id;
1055:
1056: cursor c_loan_info2(p_loan_id NUMBER, p_disb_header_id number)

Line 1062: ,lns_loan_types t

1058: select h.loan_class_code
1059: ,t.loan_type_id
1060: ,d.header_amount
1061: from lns_loan_headers_all h
1062: ,lns_loan_types t
1063: ,lns_disb_headers d
1064: where h.loan_id = p_loan_id
1065: and h.loan_type_id = t.loan_type_id
1066: and h.loan_id = d.loan_id

Line 1075: ,lns_loan_types t

1071: select h.loan_class_code
1072: ,t.loan_type_id
1073: ,ladj.adjustment_amount
1074: from lns_loan_headers_all h
1075: ,lns_loan_types t
1076: ,LNS_LOAN_AMOUNT_ADJS ladj
1077: where h.loan_id = p_loan_id
1078: and h.loan_type_id = t.loan_type_id
1079: and h.loan_id = ladj.loan_id

Line 4242: ,lns_loan_types t

4238: ,h.funded_amount)
4239: ,h.legal_entity_id
4240: ,h.LOAN_STATUS
4241: from lns_loan_headers_all h
4242: ,lns_loan_types t
4243: where h.loan_id = p_loan_id
4244: and h.loan_type_id = t.loan_type_id;
4245:
4246: -- use this to get all adjustments to be processed for the loan