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

Line 315: FROM LNS_PARTICIPANTS lp

311: x_resultout := FND_API.G_RET_STS_SUCCESS;
312: BEGIN
313: SELECT count(*)
314: INTO l_number_of_coborrowers
315: FROM LNS_PARTICIPANTS lp
316: WHERE lp.loan_id = l_cr_loan_id
317: AND lp.loan_participant_type = 'COBORROWER' ;
318:
319:

Line 382: FROM LNS_PARTICIPANTS lp

378: BEGIN
379: SELECT NVL ( (SELECT 'Y'
380: FROM DUAL
381: WHERE EXISTS ( SELECT null
382: FROM LNS_PARTICIPANTS lp
383: WHERE lp.loan_id = l_cr_loan_id
384: AND lp.loan_participant_type = 'COBORROWER'))
385: ,'N' ) INTO l_is_having_coborrowers
386: FROM DUAL ;

Line 449: FROM LNS_PARTICIPANTS lp

445: x_resultout := FND_API.G_RET_STS_SUCCESS;
446: BEGIN
447: SELECT count(*)
448: INTO l_number_of_guarantors
449: FROM LNS_PARTICIPANTS lp
450: WHERE lp.loan_id = l_cr_loan_id
451: AND lp.loan_participant_type = 'GUARANTOR' ;
452:
453:

Line 515: FROM LNS_PARTICIPANTS lp

511: BEGIN
512: SELECT NVL ( (SELECT 'Y'
513: FROM DUAL
514: WHERE EXISTS ( SELECT null
515: FROM LNS_PARTICIPANTS lp
516: WHERE lp.loan_id = l_cr_loan_id
517: AND lp.loan_participant_type = 'GUARANTOR'))
518: ,'N' ) INTO l_is_having_guarantors
519: FROM DUAL ;

Line 791: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

787: CURSOR party_total_assets(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
788: SELECT sum(VALUATION), CURRENCY_CODE
789: FROM LNS_ASSETS
790: WHERE asset_owner_id IN (
791: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
792: WHERE LOAN_ID = ( select loan_id from lns_participants
793: where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID
794: and loan_participant_type = 'PRIMARY_BORROWER' )
795: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )

Line 792: WHERE LOAN_ID = ( select loan_id from lns_participants

788: SELECT sum(VALUATION), CURRENCY_CODE
789: FROM LNS_ASSETS
790: WHERE asset_owner_id IN (
791: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
792: WHERE LOAN_ID = ( select loan_id from lns_participants
793: where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID
794: and loan_participant_type = 'PRIMARY_BORROWER' )
795: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
796:

Line 799: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

795: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
796:
797: UNION ALL
798:
799: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
800: WHERE LOAN_ID = C_LOAN_ID
801: AND HZ_PARTY_ID = C_PARTY_ID
802: AND LOAN_PARTICIPANT_TYPE = 'GUARANTOR'
803: )

Line 899: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

895: SELECT sum(nvl( (select sum (assign.pledged_amount) from lns_asset_assignments assign where LnsAssets.asset_id = assign.asset_id(+) and (assign.end_date_active is null or trunc(assign.end_date_active) > trunc(sysdate)) )
896: ,0) ), CURRENCY_CODE
897: FROM LNS_ASSETS LnsAssets
898: WHERE asset_owner_id IN (
899: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
900: WHERE LOAN_ID = ( select loan_id from lns_participants
901: where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID
902: and loan_participant_type = 'PRIMARY_BORROWER' )
903: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )

Line 900: WHERE LOAN_ID = ( select loan_id from lns_participants

896: ,0) ), CURRENCY_CODE
897: FROM LNS_ASSETS LnsAssets
898: WHERE asset_owner_id IN (
899: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
900: WHERE LOAN_ID = ( select loan_id from lns_participants
901: where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID
902: and loan_participant_type = 'PRIMARY_BORROWER' )
903: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
904:

Line 907: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

903: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
904:
905: UNION ALL
906:
907: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
908: WHERE LOAN_ID = C_LOAN_ID
909: AND HZ_PARTY_ID = C_PARTY_ID
910: AND LOAN_PARTICIPANT_TYPE = 'GUARANTOR'
911: )

Line 1008: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

1004: assign where LnsAssets.asset_id = assign.asset_id(+) and (assign.end_date_active is null or trunc(assign.end_date_active) > trunc(sysdate)) )
1005: ,0) ), CURRENCY_CODE
1006: FROM LNS_ASSETS LnsAssets
1007: WHERE asset_owner_id IN (
1008: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1009: WHERE LOAN_ID = ( select loan_id from lns_participants where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID and loan_participant_type = 'PRIMARY_BORROWER' )
1010: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
1011:
1012: UNION ALL

Line 1009: WHERE LOAN_ID = ( select loan_id from lns_participants where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID and loan_participant_type = 'PRIMARY_BORROWER' )

1005: ,0) ), CURRENCY_CODE
1006: FROM LNS_ASSETS LnsAssets
1007: WHERE asset_owner_id IN (
1008: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1009: WHERE LOAN_ID = ( select loan_id from lns_participants where loan_id = C_LOAN_ID and hz_party_id = C_PARTY_ID and loan_participant_type = 'PRIMARY_BORROWER' )
1010: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
1011:
1012: UNION ALL
1013:

Line 1014: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

1010: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
1011:
1012: UNION ALL
1013:
1014: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1015: WHERE LOAN_ID = C_LOAN_ID
1016: AND HZ_PARTY_ID = C_PARTY_ID
1017: AND LOAN_PARTICIPANT_TYPE = 'GUARANTOR'
1018: )

Line 1121: FROM lns_participants

1117: SELECT count(*)
1118: INTO l_count_active_loans
1119: FROM lns_loan_headers_all
1120: WHERE loan_id IN ( SELECT loan_id
1121: FROM lns_participants
1122: WHERE hz_party_id = l_cr_party_id
1123: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1124: OR loan_participant_type = 'COBORROWER')
1125: )

Line 1183: FROM lns_participants

1179: FROM lns_loan_headers_all llh ,
1180: LNS_PAY_SUM_V lps
1181: WHERE llh.loan_id = lps.loan_id
1182: AND llh.loan_id IN ( SELECT loan_id
1183: FROM lns_participants
1184: WHERE hz_party_id = c_party_id
1185: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1186: OR loan_participant_type = 'COBORROWER')
1187: )

Line 1286: FROM lns_participants

1282: SELECT count(*)
1283: INTO l_count_pending_loans
1284: FROM lns_loan_headers_all
1285: WHERE loan_id IN ( SELECT loan_id
1286: FROM lns_participants
1287: WHERE hz_party_id = l_cr_party_id
1288: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1289: OR loan_participant_type = 'COBORROWER')
1290: )

Line 1348: FROM lns_participants

1344: FROM lns_loan_headers_all llh ,
1345: LNS_PAY_SUM_V lps
1346: WHERE llh.loan_id = lps.loan_id
1347: AND llh.loan_id IN ( SELECT loan_id
1348: FROM lns_participants
1349: WHERE hz_party_id = c_party_id
1350: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1351: OR loan_participant_type = 'COBORROWER')
1352: )

Line 1450: FROM lns_participants

1446: SELECT count(*)
1447: INTO l_count_delinquent_loans
1448: FROM lns_loan_headers_all
1449: WHERE loan_id IN ( SELECT loan_id
1450: FROM lns_participants
1451: WHERE hz_party_id = l_cr_party_id
1452: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1453: OR loan_participant_type = 'COBORROWER')
1454: )

Line 1512: FROM lns_participants

1508: FROM lns_loan_headers_all llh ,
1509: LNS_PAY_SUM_V lps
1510: WHERE llh.loan_id = lps.loan_id
1511: AND llh.loan_id IN ( SELECT loan_id
1512: FROM lns_participants
1513: WHERE hz_party_id = c_party_id
1514: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1515: OR loan_participant_type = 'COBORROWER')
1516: )

Line 1615: FROM lns_participants

1611: SELECT count(*)
1612: INTO l_count_default_loans
1613: FROM lns_loan_headers_all
1614: WHERE loan_id IN ( SELECT loan_id
1615: FROM lns_participants
1616: WHERE hz_party_id = l_cr_party_id
1617: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1618: OR loan_participant_type = 'COBORROWER')
1619: )

Line 1676: FROM lns_participants

1672: FROM lns_loan_headers_all llh ,
1673: LNS_PAY_SUM_V lps
1674: WHERE llh.loan_id = lps.loan_id
1675: AND llh.loan_id IN ( SELECT loan_id
1676: FROM lns_participants
1677: WHERE hz_party_id = c_party_id
1678: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1679: OR loan_participant_type = 'COBORROWER')
1680: )

Line 1778: FROM lns_participants

1774: SELECT count(*)
1775: INTO l_count_paidoff_loans
1776: FROM lns_loan_headers_all
1777: WHERE loan_id IN ( SELECT loan_id
1778: FROM lns_participants
1779: WHERE hz_party_id = l_cr_party_id
1780: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1781: OR loan_participant_type = 'COBORROWER')
1782: )

Line 1839: FROM lns_participants

1835: FROM lns_loan_headers_all llh ,
1836: LNS_PAY_SUM_V lps
1837: WHERE llh.loan_id = lps.loan_id
1838: AND llh.loan_id IN ( SELECT loan_id
1839: FROM lns_participants
1840: WHERE hz_party_id = c_party_id
1841: AND ( loan_participant_type = 'PRIMARY_BORROWER'
1842: OR loan_participant_type = 'COBORROWER')
1843: )

Line 1947: FROM lns_participants

1943: SELECT count(*)
1944: INTO l_total_active_loans
1945: FROM lns_loan_headers_all
1946: WHERE loan_id IN ( SELECT loan_id
1947: FROM lns_participants
1948: WHERE hz_party_id IN ( SELECT hz_party_id
1949: FROM lns_participants
1950: WHERE loan_id = l_cr_loan_id
1951: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )

Line 1949: FROM lns_participants

1945: FROM lns_loan_headers_all
1946: WHERE loan_id IN ( SELECT loan_id
1947: FROM lns_participants
1948: WHERE hz_party_id IN ( SELECT hz_party_id
1949: FROM lns_participants
1950: WHERE loan_id = l_cr_loan_id
1951: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
1952: AND EXISTS ( select null from lns_participants
1953: where loan_id = l_cr_loan_id

Line 1952: AND EXISTS ( select null from lns_participants

1948: WHERE hz_party_id IN ( SELECT hz_party_id
1949: FROM lns_participants
1950: WHERE loan_id = l_cr_loan_id
1951: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
1952: AND EXISTS ( select null from lns_participants
1953: where loan_id = l_cr_loan_id
1954: and hz_party_id = l_cr_party_id
1955: and loan_participant_type = 'PRIMARY_BORROWER' )
1956:

Line 1960: FROM lns_participants

1956:
1957: UNION ALL
1958:
1959: SELECT hz_party_id
1960: FROM lns_participants
1961: WHERE loan_id = l_cr_loan_id
1962: AND hz_party_id = l_cr_party_id
1963: AND loan_participant_type = 'GUARANTOR'
1964: )

Line 2030: FROM lns_participants

2026: FROM lns_loan_headers_all llh ,
2027: LNS_PAY_SUM_V lps
2028: WHERE llh.loan_id = lps.loan_id
2029: AND llh.loan_id IN ( SELECT loan_id
2030: FROM lns_participants
2031: WHERE hz_party_id IN ( SELECT hz_party_id
2032: FROM lns_participants
2033: WHERE loan_id = c_loan_id
2034: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )

Line 2032: FROM lns_participants

2028: WHERE llh.loan_id = lps.loan_id
2029: AND llh.loan_id IN ( SELECT loan_id
2030: FROM lns_participants
2031: WHERE hz_party_id IN ( SELECT hz_party_id
2032: FROM lns_participants
2033: WHERE loan_id = c_loan_id
2034: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2035: AND EXISTS ( select null from lns_participants where loan_id = c_loan_id and hz_party_id = c_party_id and loan_participant_type = 'PRIMARY_BORROWER' )
2036:

Line 2035: AND EXISTS ( select null from lns_participants where loan_id = c_loan_id and hz_party_id = c_party_id and loan_participant_type = 'PRIMARY_BORROWER' )

2031: WHERE hz_party_id IN ( SELECT hz_party_id
2032: FROM lns_participants
2033: WHERE loan_id = c_loan_id
2034: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2035: AND EXISTS ( select null from lns_participants where loan_id = c_loan_id and hz_party_id = c_party_id and loan_participant_type = 'PRIMARY_BORROWER' )
2036:
2037: UNION ALL
2038:
2039: SELECT hz_party_id

Line 2040: FROM lns_participants

2036:
2037: UNION ALL
2038:
2039: SELECT hz_party_id
2040: FROM lns_participants
2041: WHERE loan_id = c_loan_id
2042: AND hz_party_id = c_party_id
2043: AND loan_participant_type = 'GUARANTOR'
2044: )

Line 2150: FROM lns_participants

2146: SELECT count(*)
2147: INTO l_total_deliquent_loans
2148: FROM lns_loan_headers_all
2149: WHERE loan_id IN ( SELECT loan_id
2150: FROM lns_participants
2151: WHERE hz_party_id IN ( SELECT hz_party_id
2152: FROM lns_participants
2153: WHERE loan_id = l_cr_loan_id
2154: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )

Line 2152: FROM lns_participants

2148: FROM lns_loan_headers_all
2149: WHERE loan_id IN ( SELECT loan_id
2150: FROM lns_participants
2151: WHERE hz_party_id IN ( SELECT hz_party_id
2152: FROM lns_participants
2153: WHERE loan_id = l_cr_loan_id
2154: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2155: AND EXISTS ( select null from lns_participants
2156: where loan_id = l_cr_loan_id

Line 2155: AND EXISTS ( select null from lns_participants

2151: WHERE hz_party_id IN ( SELECT hz_party_id
2152: FROM lns_participants
2153: WHERE loan_id = l_cr_loan_id
2154: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2155: AND EXISTS ( select null from lns_participants
2156: where loan_id = l_cr_loan_id
2157: and hz_party_id = l_cr_party_id
2158: and loan_participant_type = 'PRIMARY_BORROWER' )
2159:

Line 2163: FROM lns_participants

2159:
2160: UNION ALL
2161:
2162: SELECT hz_party_id
2163: FROM lns_participants
2164: WHERE loan_id = l_cr_loan_id
2165: AND hz_party_id = l_cr_party_id
2166: AND loan_participant_type = 'GUARANTOR'
2167: )

Line 2231: FROM lns_participants

2227: FROM lns_loan_headers_all llh ,
2228: LNS_PAY_SUM_OVERDUE_V lps
2229: WHERE llh.loan_id = lps.loan_id
2230: AND llh.loan_id IN ( SELECT loan_id
2231: FROM lns_participants
2232: WHERE hz_party_id IN ( SELECT hz_party_id
2233: FROM lns_participants
2234: WHERE loan_id = c_loan_id
2235: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )

Line 2233: FROM lns_participants

2229: WHERE llh.loan_id = lps.loan_id
2230: AND llh.loan_id IN ( SELECT loan_id
2231: FROM lns_participants
2232: WHERE hz_party_id IN ( SELECT hz_party_id
2233: FROM lns_participants
2234: WHERE loan_id = c_loan_id
2235: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2236: AND EXISTS ( select null from lns_participants where loan_id = c_loan_id and hz_party_id = c_party_id and loan_participant_type = 'PRIMARY_BORROWER' )
2237:

Line 2236: AND EXISTS ( select null from lns_participants where loan_id = c_loan_id and hz_party_id = c_party_id and loan_participant_type = 'PRIMARY_BORROWER' )

2232: WHERE hz_party_id IN ( SELECT hz_party_id
2233: FROM lns_participants
2234: WHERE loan_id = c_loan_id
2235: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2236: AND EXISTS ( select null from lns_participants where loan_id = c_loan_id and hz_party_id = c_party_id and loan_participant_type = 'PRIMARY_BORROWER' )
2237:
2238: UNION ALL
2239:
2240: SELECT hz_party_id

Line 2241: FROM lns_participants

2237:
2238: UNION ALL
2239:
2240: SELECT hz_party_id
2241: FROM lns_participants
2242: WHERE loan_id = c_loan_id
2243: AND hz_party_id = c_party_id
2244: AND loan_participant_type = 'GUARANTOR'
2245: )

Line 2352: FROM lns_participants

2348: SELECT count(*)
2349: INTO l_total_default_loans
2350: FROM lns_loan_headers_all
2351: WHERE loan_id IN ( SELECT loan_id
2352: FROM lns_participants
2353: WHERE hz_party_id IN ( SELECT hz_party_id
2354: FROM lns_participants
2355: WHERE loan_id = l_cr_loan_id
2356: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )

Line 2354: FROM lns_participants

2350: FROM lns_loan_headers_all
2351: WHERE loan_id IN ( SELECT loan_id
2352: FROM lns_participants
2353: WHERE hz_party_id IN ( SELECT hz_party_id
2354: FROM lns_participants
2355: WHERE loan_id = l_cr_loan_id
2356: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2357: AND EXISTS ( select null from lns_participants
2358: where loan_id = l_cr_loan_id

Line 2357: AND EXISTS ( select null from lns_participants

2353: WHERE hz_party_id IN ( SELECT hz_party_id
2354: FROM lns_participants
2355: WHERE loan_id = l_cr_loan_id
2356: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2357: AND EXISTS ( select null from lns_participants
2358: where loan_id = l_cr_loan_id
2359: and hz_party_id = l_cr_party_id
2360: and loan_participant_type = 'PRIMARY_BORROWER' )
2361:

Line 2365: FROM lns_participants

2361:
2362: UNION ALL
2363:
2364: SELECT hz_party_id
2365: FROM lns_participants
2366: WHERE loan_id = l_cr_loan_id
2367: AND hz_party_id = l_cr_party_id
2368: AND loan_participant_type = 'GUARANTOR'
2369: )