APPS.LNS_UTILITY_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 806: from lns_loan_headers_all

802: begin
803:
804: /* 6-3-2005 raverma always return Y
805: select org_id into l_org_id
806: from lns_loan_headers_all
807: where loan_id = p_loan_id;
808:
809: return Check_PSA_Enabled_Org(l_org_id);
810: */

Line 1164: FROM lns_participants participant, LNS_LOAN_HEADERS_ALL header

1160:
1161: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' Subject_ID - ' || l_subject_id);
1162:
1163: SELECT count(participant.loan_id) INTO l_number_of_loans
1164: FROM lns_participants participant, LNS_LOAN_HEADERS_ALL header
1165: WHERE participant.loan_participant_type in ('PRIMARY_BORROWER','COBORROWER','GUARANTOR')
1166: AND participant.loan_id = header.loan_id
1167: AND header.org_id = l_org_id
1168: AND -- participant.hz_party_id in