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.

[Home] [Help]

APPS.LNS_OCM_ADP_PUB dependencies on LNS_PARTICIPANTS

Line 317: FROM LNS_PARTICIPANTS lp

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

Line 384: FROM LNS_PARTICIPANTS lp

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

Line 451: FROM LNS_PARTICIPANTS lp

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

Line 517: FROM LNS_PARTICIPANTS lp

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

Line 793: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

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

Line 794: WHERE LOAN_ID = ( select loan_id from lns_participants

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

Line 801: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

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

Line 901: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

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

Line 902: WHERE LOAN_ID = ( select loan_id from lns_participants

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

Line 909: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

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

Line 1010: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

1006: assign where LnsAssets.asset_id = assign.asset_id(+) and (assign.end_date_active is null or trunc(assign.end_date_active) > trunc(sysdate)) )
1007: ,0) ), CURRENCY_CODE
1008: FROM LNS_ASSETS LnsAssets
1009: WHERE asset_owner_id IN (
1010: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1011: 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' )
1012: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
1013:
1014: UNION ALL

Line 1011: 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' )

1007: ,0) ), CURRENCY_CODE
1008: FROM LNS_ASSETS LnsAssets
1009: WHERE asset_owner_id IN (
1010: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS
1011: 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' )
1012: AND ( LOAN_PARTICIPANT_TYPE = 'PRIMARY_BORROWER' OR LOAN_PARTICIPANT_TYPE ='COBORROWER' )
1013:
1014: UNION ALL
1015:

Line 1016: SELECT HZ_PARTY_ID FROM LNS_PARTICIPANTS

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

Line 1123: FROM lns_participants

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

Line 1185: FROM lns_participants

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

Line 1288: FROM lns_participants

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

Line 1350: FROM lns_participants

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

Line 1452: FROM lns_participants

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

Line 1514: FROM lns_participants

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

Line 1617: FROM lns_participants

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

Line 1678: FROM lns_participants

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

Line 1780: FROM lns_participants

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

Line 1841: FROM lns_participants

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

Line 1949: FROM lns_participants

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

Line 1951: FROM lns_participants

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

Line 1954: AND EXISTS ( select null from lns_participants

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

Line 1962: FROM lns_participants

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

Line 2032: FROM lns_participants

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

Line 2034: FROM lns_participants

2030: WHERE llh.loan_id = lps.loan_id
2031: AND llh.loan_id IN ( SELECT loan_id
2032: FROM lns_participants
2033: WHERE hz_party_id IN ( SELECT hz_party_id
2034: FROM lns_participants
2035: WHERE loan_id = c_loan_id
2036: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2037: 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' )
2038:

Line 2037: 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' )

2033: WHERE hz_party_id IN ( SELECT hz_party_id
2034: FROM lns_participants
2035: WHERE loan_id = c_loan_id
2036: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2037: 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' )
2038:
2039: UNION ALL
2040:
2041: SELECT hz_party_id

Line 2042: FROM lns_participants

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

Line 2152: FROM lns_participants

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

Line 2154: FROM lns_participants

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

Line 2157: AND EXISTS ( select null from lns_participants

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

Line 2165: FROM lns_participants

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

Line 2233: FROM lns_participants

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

Line 2235: FROM lns_participants

2231: WHERE llh.loan_id = lps.loan_id
2232: AND llh.loan_id IN ( SELECT loan_id
2233: FROM lns_participants
2234: WHERE hz_party_id IN ( SELECT hz_party_id
2235: FROM lns_participants
2236: WHERE loan_id = c_loan_id
2237: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2238: 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' )
2239:

Line 2238: 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' )

2234: WHERE hz_party_id IN ( SELECT hz_party_id
2235: FROM lns_participants
2236: WHERE loan_id = c_loan_id
2237: AND (loan_participant_type = 'PRIMARY_BORROWER' or loan_participant_type = 'COBORROWER' )
2238: 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' )
2239:
2240: UNION ALL
2241:
2242: SELECT hz_party_id

Line 2243: FROM lns_participants

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

Line 2354: FROM lns_participants

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

Line 2356: FROM lns_participants

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

Line 2359: AND EXISTS ( select null from lns_participants

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

Line 2367: FROM lns_participants

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