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_PAY_SUM_V

Line 1182: LNS_PAY_SUM_V lps

1178:
1179: CURSOR active_loans_balance(C_PARTY_ID NUMBER) IS
1180: SELECT sum(lps.total_principal_balance) , llh.loan_currency
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

Line 1347: LNS_PAY_SUM_V lps

1343:
1344: CURSOR pending_loans_balance(C_PARTY_ID NUMBER) IS
1345: SELECT sum(lps.total_principal_balance) , llh.loan_currency
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

Line 1511: LNS_PAY_SUM_V lps

1507:
1508: CURSOR delinquent_loans_balance(C_PARTY_ID NUMBER) IS
1509: SELECT sum(lps.total_principal_balance) , llh.loan_currency
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

Line 1675: LNS_PAY_SUM_V lps

1671:
1672: CURSOR default_loans_balance(C_PARTY_ID NUMBER) IS
1673: SELECT sum(lps.total_principal_balance) , llh.loan_currency
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

Line 1838: LNS_PAY_SUM_V lps

1834:
1835: CURSOR paidoff_loans_balance(C_PARTY_ID NUMBER) IS
1836: SELECT sum(lps.total_principal_balance) , llh.loan_currency
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

Line 2029: LNS_PAY_SUM_V lps

2025:
2026: CURSOR total_active_loans_balance(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
2027: SELECT sum( nvl(lps.total_principal_balance,0) ) , llh.loan_currency
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