DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on GL_PERIOD_STATUSES

Line 1488: , gl_period_statuses glps

1484: SELECT MIN(TIM.start_date) first_open
1485: INTO l_report_date
1486: FROM
1487: pji_time_cal_period_v TIM
1488: , gl_period_statuses glps
1489: , pa_implementations_all paimp
1490: WHERE 1=1
1491: AND TIM.calendar_id = l_calendar_id
1492: AND paimp.set_of_books_id = glps.set_of_books_id

Line 1502: , gl_period_statuses glps

1498: SELECT MAX(TIM.start_date) last_open
1499: INTO l_report_date
1500: FROM
1501: pji_time_cal_period_v TIM
1502: , gl_period_statuses glps
1503: , pa_implementations_all paimp
1504: WHERE 1=1
1505: AND TIM.calendar_id = l_calendar_id
1506: AND paimp.set_of_books_id = glps.set_of_books_id

Line 1516: , gl_period_statuses glps

1512: SELECT MAX(TIM.start_date) last_closed
1513: INTO l_report_date
1514: FROM
1515: pji_time_cal_period_v TIM
1516: , gl_period_statuses glps
1517: , pa_implementations_all paimp
1518: WHERE 1=1
1519: AND TIM.calendar_id = l_calendar_id
1520: AND paimp.set_of_books_id = glps.set_of_books_id