DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on GL_PERIOD_STATUSES

Line 1371: , gl_period_statuses glps

1367: SELECT MIN(TIM.start_date) first_open
1368: INTO l_report_date
1369: FROM
1370: pji_time_cal_period_v TIM
1371: , gl_period_statuses glps
1372: , pa_implementations_all paimp
1373: WHERE 1=1
1374: AND TIM.calendar_id = l_calendar_id
1375: AND paimp.set_of_books_id = glps.set_of_books_id

Line 1385: , gl_period_statuses glps

1381: SELECT MAX(TIM.start_date) last_open
1382: INTO l_report_date
1383: FROM
1384: pji_time_cal_period_v TIM
1385: , gl_period_statuses glps
1386: , pa_implementations_all paimp
1387: WHERE 1=1
1388: AND TIM.calendar_id = l_calendar_id
1389: AND paimp.set_of_books_id = glps.set_of_books_id

Line 1399: , gl_period_statuses glps

1395: SELECT MAX(TIM.start_date) last_closed
1396: INTO l_report_date
1397: FROM
1398: pji_time_cal_period_v TIM
1399: , gl_period_statuses glps
1400: , pa_implementations_all paimp
1401: WHERE 1=1
1402: AND TIM.calendar_id = l_calendar_id
1403: AND paimp.set_of_books_id = glps.set_of_books_id