APPS.LNS_APPROVAL_ACTION_PUB dependencies on AR_ADJUSTMENTS_ALL

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