APPS.GL_FUNDS_AVAILABLE_PKG dependencies on GL_PERIOD_STATUSES

Line 302: from gl_period_statuses

298: and arr.affect_funds_flag = 'Y';
299:
300: cursor c_pjtd(x_application_id NUMBER) is
301: select period_name, period_num, period_year, quarter_num
302: from gl_period_statuses
303: where application_id = x_application_id
304: and ledger_id = x_ledger_id
305: and period_name = (select latest_opened_period_name
306: from gl_ledgers

Line 330: gl_period_statuses_pkg.select_year_1st_period(

326:
327: BEGIN
328: IF (x_amount_type in ('QTDE', 'YTDE', 'PJTD')) THEN
329: IF (x_amount_type = 'YTDE') THEN
330: gl_period_statuses_pkg.select_year_1st_period(
331: 101,
332: x_ledger_id,
333: x_period_year,
334: x_first_period_of_year_name );

Line 344: gl_period_statuses_pkg.get_extended_quarter(

340: x_year_used_for_ext_actuals := x_period_year;
341: x_quarter_used_for_ext_actuals := x_quarter_num;
342: ELSIF (x_amount_type = 'QTDE') /* x_closing_status IN ( 'N', 'F' ) */
343: THEN
344: gl_period_statuses_pkg.get_extended_quarter(
345: 101,
346: x_ledger_id,
347: x_period_year,
348: x_period_name,

Line 356: gl_period_statuses_pkg.get_extended_year(

352: x_num_used_for_ext_actuals,
353: x_year_used_for_ext_actuals,
354: x_quarter_used_for_ext_actuals );
355: ELSIF x_amount_type = 'YTDE' then /* x_closing_status IN ('N', 'F') */
356: gl_period_statuses_pkg.get_extended_year(
357: 101,
358: x_ledger_id,
359: x_period_year,
360: x_accounted_period_type,

Line 670: FROM Gl_Period_Statuses

666: p_currency_code IN VARCHAR2) RETURN NUMBER IS
667:
668: CURSOR c_get_period_info(cp_ledger_id NUMBER, cp_period_name VARCHAR2) IS
669: SELECT period_num, quarter_num, period_year, closing_status
670: FROM Gl_Period_Statuses
671: WHERE application_id = 201
672: AND ledger_id = cp_ledger_id
673: AND period_name = cp_period_name;
674: