DBA Data[Home] [Help]

APPS.AP_APXINRIR_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 349: l_start_date gl_period_statuses.start_date%TYPE;

345: FUNCTION set_p_where RETURN BOOLEAN IS
346:
347: l_nls_yes varchar2(4);
348: l_type_of_report varchar2(40);
349: l_start_date gl_period_statuses.start_date%TYPE;
350: l_end_date gl_period_statuses.end_date%TYPE;
351:
352:
353: BEGIN

Line 350: l_end_date gl_period_statuses.end_date%TYPE;

346:
347: l_nls_yes varchar2(4);
348: l_type_of_report varchar2(40);
349: l_start_date gl_period_statuses.start_date%TYPE;
350: l_end_date gl_period_statuses.end_date%TYPE;
351:
352:
353: BEGIN
354:

Line 515: FROM gl_period_statuses

511: if P_ACCOUNTING_PERIOD is not null then
512: BEGIN
513: SELECT start_date, end_date
514: INTO l_start_date, l_end_date
515: FROM gl_period_statuses
516: WHERE period_name = P_ACCOUNTING_PERIOD
517: AND set_of_books_id = P_SOB_ID
518: AND application_id = 200
519: AND NVL(adjustment_period_flag, 'N') = 'N';