APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_LEDGERS

Line 339: GL_LEDGERS LD

335: GP.period_year*10000 + GP.period_num,
336: 'N'
337: FROM
338: GL_PERIODS GP,
339: GL_LEDGERS LD
340: WHERE GP.period_set_name = nvl(x_period_set_name, LD.period_set_name)
341: AND GP.period_name = x_period_name
342: AND LD.ledger_id = x_ledger_id;
343:

Line 422: GL_LEDGERS led

418: x_period_year * 10000 + x_period_num,
419: 'N'
420: FROM
421: GL_APPLICATION_GROUPS ag,
422: GL_LEDGERS led
423: WHERE ag.group_name = 'PERIOD_STATUS'
424: AND led.period_set_name = x_calendar_name
425: AND led.accounted_period_type = x_period_type
426: AND EXISTS ( SELECT 'Application Installed'

Line 474: FROM GL_LEDGERS led

470: ps.effective_period_num = x_period_year * 10000 + x_period_num
471: WHERE ps.period_name = x_old_period_name
472: AND ps.ledger_id IN
473: ( SELECT led.ledger_id
474: FROM GL_LEDGERS led
475: WHERE led.period_set_name = x_calendar_name );
476:
477: exception
478: WHEN NO_DATA_FOUND THEN

Line 498: FROM gl_ledgers led

494: DELETE gl_period_statuses ps
495: WHERE ps.period_name = x_old_period_name
496: AND ps.ledger_id in
497: (SELECT led.ledger_id
498: FROM gl_ledgers led
499: WHERE led.period_set_name = x_calendar_name);
500:
501: exception
502: WHEN NO_DATA_FOUND THEN

Line 584: from gl_ledgers led

580: select led.future_enterable_periods_limit,
581: led.accounted_period_type
582: into v_fut_ent_periods_limit,
583: v_period_type
584: from gl_ledgers led
585: where led.ledger_id = x_ledger_id;
586:
587: update gl_period_statuses ps
588: set ps.closing_status =

Line 650: FROM GL_LEDGERS LED,

646: PS1.start_date,
647: PS2.period_name,
648: PS2.period_year,
649: PS2.start_date
650: FROM GL_LEDGERS LED,
651: GL_PERIOD_STATUSES PS1,
652: GL_PERIOD_STATUSES PS2,
653: GL_PERIOD_TYPES GPT
654: WHERE PS1.application_id = x_application_id

Line 1238: gl_ledgers led

1234: INTO x_period_name, x_closing_status, x_period_year,
1235: x_period_num, x_period_type
1236: FROM gl_period_statuses ps,
1237: gl_date_period_map dpm,
1238: gl_ledgers led
1239: WHERE led.ledger_id = x_ledger_id
1240: AND dpm.accounting_date = x_given_date
1241: AND dpm.period_set_name = led.period_set_name
1242: AND dpm.period_type = led.accounted_period_type