APPS.AP_APXTRSWP_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 212: FROM gl_period_statuses

208:
209: IF p_period_name IS NOT NULL
210: THEN SELECT start_date, end_date
211: INTO p_start_date, p_end_date
212: FROM gl_period_statuses
213: WHERE period_name = p_period_name
214: AND application_id = 201
215: AND set_of_books_id = p_set_of_books_id;
216: ELSE IF P_FROM_ACCTG_DATE IS NOT NULL AND P_TO_ACCTG_DATE IS NOT NULL THEN

Line 910: FROM gl_period_statuses

906: /*srw.message('2', 'Sweep to Period is: '||p_to_period);*/null;
907:
908: SELECT start_date
909: INTO l_to_acctg_date
910: FROM gl_period_statuses
911: WHERE period_name = p_to_period
912: AND application_id = 200
913: AND set_of_books_id = p_set_of_books_id
914: AND nvl(adjustment_period_flag, 'N') = 'N';

Line 930: FROM gl_period_statuses

926: SELECT start_date,
927: end_date
928: INTO l_start_date,
929: l_end_date
930: FROM gl_period_statuses
931: WHERE period_name = p_period_name
932: AND application_id = 200
933: AND set_of_books_id = p_set_of_books_id
934: AND nvl(adjustment_period_flag, 'N') = 'N';