APPS.FV_SLA_PROCESSING_PKG dependencies on GL_PERIOD_STATUSES

Line 622: FROM gl_period_statuses

618:
619: CURSOR c_period (c_ledger_id NUMBER,
620: c_period_name VARCHAR2) IS
621: SELECT period_year, period_num
622: FROM gl_period_statuses
623: WHERE ledger_id = c_ledger_id
624: AND application_id = 101
625: AND period_name = c_period_name;
626:

Line 1362: FROM gl_period_statuses

1358: --Bug 7169941. Added trunc.
1359:
1360: CURSOR c_get_gl_fiscal_year IS
1361: SELECT period_year, period_name
1362: FROM gl_period_statuses
1363: WHERE ledger_id = p_ledger_id
1364: AND application_id = p_application_id
1365: AND (trunc(p_gl_date) BETWEEN start_date AND end_date)
1366: and ADJUSTMENT_PERIOD_FLAG='N';

Line 1498: FROM Gl_Period_Statuses

1494: l_header_id NUMBER;
1495:
1496: CURSOR c_get_gl_fiscal_year(cp_ledger_id NUMBER, cp_gl_date DATE) IS
1497: SELECT period_year, period_name
1498: FROM Gl_Period_Statuses
1499: WHERE ledger_id = cp_ledger_id
1500: AND cp_gl_date BETWEEN START_DATE AND end_date ;
1501:
1502: l_transaction_year c_get_gl_fiscal_year%ROWTYPE;

Line 2176: FROM Gl_Period_Statuses

2172: WHERE event_id = p_event_id;
2173:
2174: CURSOR c_get_gl_fiscal_year(p_ledger_id NUMBER, p_gl_date DATE) IS
2175: SELECT period_year, period_name
2176: FROM Gl_Period_Statuses
2177: WHERE ledger_id = p_ledger_id
2178: AND p_gl_date BETWEEN START_DATE AND end_date ;
2179:
2180: l_accounting_mode VARCHAR2(20);

Line 2494: FROM Gl_Period_Statuses

2490: WHERE event_id = p_event_id;
2491:
2492: CURSOR c_get_gl_fiscal_year(p_ledger_id NUMBER, p_gl_date DATE) IS
2493: SELECT period_year, period_name
2494: FROM Gl_Period_Statuses
2495: WHERE ledger_id = p_ledger_id
2496: AND p_gl_date BETWEEN START_DATE AND end_date ;
2497:
2498: l_accounting_mode VARCHAR2(20);