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_APPROVAL_ACTION_PUB dependencies on LNS_LOAN_LINES

Line 561: from ar_adjustments_all adj, lns_loan_lines lines

557: where loan_id = p_loan_id;
558:
559: cursor c_gl_date (p_loan_id number) is
560: select adj.gl_date
561: from ar_adjustments_all adj, lns_loan_lines lines
562: where lines.loan_id = p_loan_id
563: and lines.STATUS = 'APPROVED'
564: and lines.end_date is null
565: and lines.rec_adjustment_id = adj.adjustment_id

Line 1650: from lns_loan_lines line,

1646: nvl(loan.FUNDED_AMOUNT, 0),
1647: nvl(loan.ADD_REQUESTED_AMOUNT, 0),
1648: loan.loan_status,
1649: loan.OBJECT_VERSION_NUMBER
1650: from lns_loan_lines line,
1651: lns_loan_headers_all loan
1652: where line.loan_line_id = P_LOAN_LINE_ID and
1653: line.loan_id = loan.loan_id;
1654:

Line 1661: OWNER_TABLE = 'LNS_LOAN_LINES' and

1657: select count(1)
1658: from LNS_COND_ASSIGNMENTS
1659: where
1660: OWNER_OBJECT_ID = P_LOAN_LINE_ID and
1661: OWNER_TABLE = 'LNS_LOAN_LINES' and
1662: MANDATORY_FLAG = 'Y' and
1663: (CONDITION_MET_FLAG is null or CONDITION_MET_FLAG = 'N') and
1664: (end_date_active is null or trunc(end_date_active) > trunc(sysdate));
1665: