APPS.PA_RP_UTIL dependencies on PJI_TIME_CAL_PERIOD_V

Line 908: pji_time_cal_period_v TIM

904: IF l_active_rep ='FIRST_OPEN' THEN
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

Line 921: pji_time_cal_period_v TIM

917: ELSIF l_active_rep = 'LAST_OPEN' THEN
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

Line 934: pji_time_cal_period_v TIM

930: ELSIF l_active_rep = 'LAST_CLOSED' THEN
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

Line 946: FROM pji_time_cal_period_v

942: AND closing_status = 'C';
943: ELSIF l_active_rep IN ('CURRENT','PRIOR') THEN
944: SELECT start_date
945: INTO l_report_date
946: FROM pji_time_cal_period_v
947: WHERE TRUNC(SYSDATE) BETWEEN start_date
948: AND end_date
949: AND calendar_id = x_calendar_id;
950: END IF;

Line 955: FROM pji_time_cal_period_v

951:
952: IF l_active_rep = 'PRIOR' THEN
953: SELECT MAX(start_date)
954: INTO l_report_date
955: FROM pji_time_cal_period_v
956: WHERE end_date < l_report_date
957: AND calendar_id = x_calendar_id;
958: END IF;
959:

Line 963: FROM pji_time_cal_period_v

959:
960: if l_active_rep = 'SPECIFIC' then
961: SELECT name, cal_period_id, start_date, end_date, start_date
962: INTO x_period_name, x_period_id, l_start_date, l_end_date, l_report_date
963: FROM pji_time_cal_period_v
964: WHERE name = p_spec_period_name
965: AND calendar_id = x_calendar_id;
966: else
967: SELECT name, cal_period_id, start_date, end_date

Line 969: FROM pji_time_cal_period_v

965: AND calendar_id = x_calendar_id;
966: else
967: SELECT name, cal_period_id, start_date, end_date
968: INTO x_period_name, x_period_id, l_start_date, l_end_date
969: FROM pji_time_cal_period_v
970: WHERE l_report_date BETWEEN start_date AND end_date
971: AND calendar_id = x_calendar_id;
972: end if;
973: