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_DISTRIBUTIONS_PUB dependencies on GL_PERIOD_STATUSES

Line 9103: GL_PERIOD_STATUSES glps, LNS_SYSTEM_OPTIONS sysopt, LNS_LOAN_HEADERS lhdr

9099: CURSOR cur_gl_period_status(C_LOAN_ID Number, C_PERIOD_NAME Varchar2) IS
9100: SELECT
9101: glps.closing_status
9102: FROM
9103: GL_PERIOD_STATUSES glps, LNS_SYSTEM_OPTIONS sysopt, LNS_LOAN_HEADERS lhdr
9104: WHERE lhdr.loan_id = C_LOAN_ID
9105: AND lhdr.org_id = sysopt.org_id
9106: AND sysopt.set_of_books_id = glps.ledger_id
9107: AND glps.application_id = 101

Line 9598: l_gl_period_name gl_period_statuses.PERIOD_NAME%TYPE;

9594: l_loan_id NUMBER;
9595: l_borrower_id NUMBER;
9596: l_ledger_id NUMBER;
9597: l_gl_period_status VARCHAR2(1);
9598: l_gl_period_name gl_period_statuses.PERIOD_NAME%TYPE;
9599:
9600: l_loans_to_accrue_tbl g_number_tbl;
9601:
9602: L_EXC_WARNING EXCEPTION;

Line 9634: GL_PERIOD_STATUSES glps

9630: CURSOR cur_gl_period_status(C_ACCRUAL_DATE date, C_LEDGER_ID Number) IS
9631: SELECT
9632: glps.period_name, glps.closing_status
9633: FROM
9634: GL_PERIOD_STATUSES glps
9635: WHERE glps.start_date <= C_ACCRUAL_DATE
9636: AND glps.end_date >= C_ACCRUAL_DATE
9637: AND glps.ledger_id = C_LEDGER_ID
9638: AND glps.application_id = 101;

Line 9644: gl_period_statuses glpstat

9640: CURSOR cur_gl_period_last_date(c_period_name VARCHAR2, c_ledger_id NUMBER) IS
9641: SELECT
9642: to_char(glpstat.end_date,'YYYY-MM-DD')
9643: FROM
9644: gl_period_statuses glpstat
9645: WHERE
9646: glpstat.application_id = 101
9647: AND glpstat.set_of_books_id = c_ledger_id
9648: AND glpstat.period_name = c_period_name