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_UTILITY_PUB dependencies on LNS_PARTICIPANTS

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

Line 1169: participant.loan_id in (SELECT loan_id FROM lns_participants p

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
1169: participant.loan_id in (SELECT loan_id FROM lns_participants p
1170: where p.hz_party_id
1171: in
1172: (SELECT party_id FROM hz_parties
1173: WHERE party_id in