DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on GL_PERIOD_STATUSES

Line 909: , gl_period_statuses glps

905: SELECT MIN(TIM.start_date) first_open
906: INTO l_report_date
907: FROM
908: pji_time_cal_period_v TIM
909: , gl_period_statuses glps
910: , pa_implementations paimp
911: WHERE 1=1
912: AND TIM.calendar_id = x_calendar_id
913: AND paimp.set_of_books_id = glps.set_of_books_id

Line 922: , gl_period_statuses glps

918: SELECT MAX(TIM.start_date) last_open
919: INTO l_report_date
920: FROM
921: pji_time_cal_period_v TIM
922: , gl_period_statuses glps
923: , pa_implementations paimp
924: WHERE 1=1
925: AND TIM.calendar_id = x_calendar_id
926: AND paimp.set_of_books_id = glps.set_of_books_id

Line 935: , gl_period_statuses glps

931: SELECT MAX(TIM.start_date) last_closed
932: INTO l_report_date
933: FROM
934: pji_time_cal_period_v TIM
935: , gl_period_statuses glps
936: , pa_implementations paimp
937: WHERE 1=1
938: AND TIM.calendar_id = x_calendar_id
939: AND paimp.set_of_books_id = glps.set_of_books_id