APPS.PA_RP_UTIL dependencies on PJI_TIME_ENT_PERIOD_V

Line 887: FROM pji_time_ent_period_v

883: IF p_calendar_type = 'E' THEN
884: IF l_active_rep IN ('CURRENT','PRIOR') THEN
885: SELECT start_date
886: INTO l_report_date
887: FROM pji_time_ent_period_v
888: WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;
889: END IF;
890:
891: IF l_active_rep = 'PRIOR' THEN

Line 894: FROM pji_time_ent_period_v

890:
891: IF l_active_rep = 'PRIOR' THEN
892: SELECT MAX(start_date)
893: INTO l_report_date
894: FROM pji_time_ent_period_v
895: WHERE end_date 896: END IF;
897:
898: SELECT name, ent_period_id, start_date, end_date

Line 900: FROM pji_time_ent_period_v

896: END IF;
897:
898: SELECT name, ent_period_id, start_date, end_date
899: INTO x_period_name, x_period_id, l_start_date, l_end_date
900: FROM pji_time_ent_period_v
901: WHERE l_report_date BETWEEN start_date AND end_date;
902:
903: ELSE
904: IF l_active_rep ='FIRST_OPEN' THEN