APPS.GL_FUNDS_AVAILABLE_PKG dependencies on GL_PERIOD_STATUSES

Line 301: from gl_period_statuses

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

Line 329: gl_period_statuses_pkg.select_year_1st_period(

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

Line 343: gl_period_statuses_pkg.get_extended_quarter(

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

Line 355: gl_period_statuses_pkg.get_extended_year(

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

Line 669: FROM Gl_Period_Statuses

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