DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on HR_OPERATING_UNITS

Line 9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl

9038: CURSOR loan_cur(C_LOAN_ID number) IS
9039: SELECT
9040: loan.loan_number, nvl(loan.disable_int_accrual_flag, 'N'), ou.name, gl.name
9041: FROM
9042: lns_loan_headers_all loan, lns_system_options_all lsysopt, hr_operating_units ou, gl_ledgers gl
9043: WHERE loan.loan_id = C_LOAN_ID
9044: AND loan.org_id = lsysopt.org_id
9045: AND lsysopt.set_of_books_id = gl.ledger_id
9046: AND loan.org_id = ou.organization_id;