DBA Data[Home] [Help]

APPS.PA_CALENDAR_UTILS dependencies on JTF_CAL_EXCEPTIONS_B

Line 127: FROM JTF_CAL_EXCEPTIONS_B CALEXP, JTF_CAL_EXCEPTION_ASSIGN CALASN

123: -- This cursor will select the exceptions assign to the pased calendar
124: /* Added trunc for calexp.start_Date_time bug 4176843 */
125: CURSOR C1 IS SELECT calexp.exception_id, trunc(calexp.start_date_time) start_date_time,
126: trunc(calexp.end_date_time) end_date_time,calexp.exception_category
127: FROM JTF_CAL_EXCEPTIONS_B CALEXP, JTF_CAL_EXCEPTION_ASSIGN CALASN
128: WHERE calasn.calendar_id = p_calendar_id
129: AND calasn.exception_id = calexp.exception_id;
130: BEGIN
131: l_I := 1;