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 3366: from gl_periods per,

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

Line 3378: l_min_period_name gl_periods.period_name%TYPE;

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

Line 3379: l_max_period_name gl_periods.period_name%TYPE;

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