APPS.AR_ARXINREV_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 68: from gl_period_statuses gl

64: /*SRW.MESSAGE('7','After Selecting Set Of Books Id, Company Name');*/null;
65: END IF;
66: select end_date
67: into P_END_DATE
68: from gl_period_statuses gl
69: where gl.set_of_books_id = P_SET_OF_BOOKS_ID and gl.application_id = 222
70: and gl.period_name = P_REVALUATION_PERIOD;
71: LP_END_DATE:=P_END_DATE;
72: select min(start_date)

Line 74: from gl_period_statuses gl

70: and gl.period_name = P_REVALUATION_PERIOD;
71: LP_END_DATE:=P_END_DATE;
72: select min(start_date)
73: into acc_start_date
74: from gl_period_statuses gl
75: where gl.set_of_books_id = P_SET_OF_BOOKS_ID
76: and gl.application_id=222;
77: IF arp_util.open_period_exists('3000',acc_org_id,acc_start_date,p_end_date) THEN
78: FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');