APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on GL_PERIOD_STATUSES

Line 1246: from gl_period_statuses

1242:
1243:
1244: select count(1)
1245: into l_cnt
1246: from gl_period_statuses
1247: where application_id = l_application_id
1248: and set_of_books_id = l_set_of_books_id
1249: and adjustment_period_flag = 'N'
1250: and trunc(x_receipt_date) between trunc(start_date) and trunc(end_date)

Line 1264: from gl_period_statuses

1260: -- Check whether Sysdate is in open period or not.
1261:
1262: select count(1)
1263: into l_cnt
1264: from gl_period_statuses
1265: where application_id = l_application_id
1266: and set_of_books_id = l_set_of_books_id
1267: and adjustment_period_flag = 'N'
1268: and trunc(sysdate) between trunc(start_date) and trunc(end_date)

Line 1283: from gl_period_statuses

1279: -- Get the last date of the open period most recent to the system date
1280:
1281: select max(end_date)
1282: into l_default_gl_date
1283: from gl_period_statuses
1284: where application_id = l_application_id
1285: and set_of_books_id = l_set_of_books_id
1286: and adjustment_period_flag = 'N'
1287: and closing_status = 'O'

Line 1302: from gl_period_statuses

1298: -- Get the first date of open period after the system date
1299:
1300: select min(start_date)
1301: into l_default_gl_date
1302: from gl_period_statuses
1303: where application_id = l_application_id
1304: and set_of_books_id = l_set_of_books_id
1305: and adjustment_period_flag = 'N'
1306: and closing_status = 'O'