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_PAY_SUM_V

Line 1180: LNS_PAY_SUM_V lps

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

Line 1345: LNS_PAY_SUM_V lps

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

Line 1509: LNS_PAY_SUM_V lps

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

Line 1673: LNS_PAY_SUM_V lps

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

Line 1836: LNS_PAY_SUM_V lps

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

Line 2027: LNS_PAY_SUM_V lps

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