DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on GL_PERIODS

Line 76: | journal batches to closed GL periods. |

72: | GET_CLOSED_PERIOD_PARAM |
73: | |
74: | DESCRIPTION |
75: | This function will return the company parameter setting for posting |
76: | journal batches to closed GL periods. |
77: | CALLED BY |
78: | Procedure Journals. |
79: | Form XTRACJNL. |
80: | PARAMETERS |

Line 3367: from gl_periods per,

3363: where batch_id = l_next_bid;
3364:
3365: cursor c_acctg_period(p_journal_date DATE) is
3366: select period_name
3367: from gl_periods per,
3368: gl_sets_of_books sob,
3369: xtr_parties_v pty
3370: where pty.party_code = l_company_code
3371: and sob.set_of_books_id = pty.set_of_books_id

Line 3379: l_min_period_name gl_periods.period_name%TYPE;

3375: and per.adjustment_period_flag = 'N';
3376:
3377: l_max_journal_date DATE;
3378: l_min_journal_date DATE;
3379: l_min_period_name gl_periods.period_name%TYPE;
3380: l_max_period_name gl_periods.period_name%TYPE;
3381:
3382:
3383: BEGIN

Line 3380: l_max_period_name gl_periods.period_name%TYPE;

3376:
3377: l_max_journal_date DATE;
3378: l_min_journal_date DATE;
3379: l_min_period_name gl_periods.period_name%TYPE;
3380: l_max_period_name gl_periods.period_name%TYPE;
3381:
3382:
3383: BEGIN
3384: