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 384: FROM gl_ledgers

380: SELECT track_bc_ytd_flag, set_of_books_id
381: FROM gl_period_statuses
382: WHERE application_id = 101
383: AND set_of_books_id in (SELECT ledger_id
384: FROM gl_ledgers
385: WHERE period_set_name = x_calendar_name
386: AND accounted_period_type = x_period_type)
387: AND effective_period_num = l_Effective_period_num;
388:

Line 397: FROM gl_ledgers

393: FROM gl_period_statuses
394: WHERE application_id = 101
395: AND set_of_books_id in (
396: SELECT ledger_id
397: FROM gl_ledgers
398: WHERE period_set_name = x_calendar_name
399: AND accounted_period_type = x_period_type);
400:
401: INSERT INTO GL_PERIOD_STATUSES

Line 447: GL_LEDGERS led

443: x_period_year * 10000 + x_period_num,
444: 'N'
445: FROM
446: GL_APPLICATION_GROUPS ag,
447: GL_LEDGERS led
448: WHERE ag.group_name = 'PERIOD_STATUS'
449: AND led.period_set_name = x_calendar_name
450: AND led.accounted_period_type = x_period_type
451: AND EXISTS ( SELECT 'Application Installed'

Line 518: FROM GL_LEDGERS led

514: ps.effective_period_num = x_period_year * 10000 + x_period_num
515: WHERE ps.period_name = x_old_period_name
516: AND ps.ledger_id IN
517: ( SELECT led.ledger_id
518: FROM GL_LEDGERS led
519: WHERE led.period_set_name = x_calendar_name );
520:
521: exception
522: WHEN NO_DATA_FOUND THEN

Line 542: FROM gl_ledgers led

538: DELETE gl_period_statuses ps
539: WHERE ps.period_name = x_old_period_name
540: AND ps.ledger_id in
541: (SELECT led.ledger_id
542: FROM gl_ledgers led
543: WHERE led.period_set_name = x_calendar_name);
544:
545: exception
546: WHEN NO_DATA_FOUND THEN

Line 628: from gl_ledgers led

624: select led.future_enterable_periods_limit,
625: led.accounted_period_type
626: into v_fut_ent_periods_limit,
627: v_period_type
628: from gl_ledgers led
629: where led.ledger_id = x_ledger_id;
630:
631: update gl_period_statuses ps
632: set ps.closing_status =

Line 694: FROM GL_LEDGERS LED,

690: PS1.start_date,
691: PS2.period_name,
692: PS2.period_year,
693: PS2.start_date
694: FROM GL_LEDGERS LED,
695: GL_PERIOD_STATUSES PS1,
696: GL_PERIOD_STATUSES PS2,
697: GL_PERIOD_TYPES GPT
698: WHERE PS1.application_id = x_application_id

Line 1282: gl_ledgers led

1278: INTO x_period_name, x_closing_status, x_period_year,
1279: x_period_num, x_period_type
1280: FROM gl_period_statuses ps,
1281: gl_date_period_map dpm,
1282: gl_ledgers led
1283: WHERE led.ledger_id = x_ledger_id
1284: AND dpm.accounting_date = x_given_date
1285: AND dpm.period_set_name = led.period_set_name
1286: AND dpm.period_type = led.accounted_period_type