DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PVT dependencies on GL_PERIODS_V

Line 3243: FROM gl_periods_v

3239: SELECT 1
3240: FROM dual
3241: WHERE EXISTS (
3242: SELECT 1
3243: FROM gl_periods_v
3244: WHERE period_set_name = p_deliv_rec.deliverable_calendar
3245: AND period_name = l_name)
3246: ;
3247: BEGIN

Line 3391: FROM gl_periods_v

3387: CURSOR c_calendar (l_calendar_name IN VARCHAR2) IS
3388: SELECT 1
3389: FROM dual
3390: WHERE EXISTS (SELECT 1
3391: FROM gl_periods_v
3392: WHERE period_set_name = l_calendar_name);
3393:
3394: CURSOR c_period (l_name IN VARCHAR2) IS
3395: SELECT start_date, end_date

Line 3396: FROM gl_periods_v

3392: WHERE period_set_name = l_calendar_name);
3393:
3394: CURSOR c_period (l_name IN VARCHAR2) IS
3395: SELECT start_date, end_date
3396: FROM gl_periods_v
3397: WHERE period_set_name = p_deliv_rec.deliverable_calendar
3398: AND period_name = l_name;
3399: l_start_rec c_period%ROWTYPE;
3400: l_end_rec c_period%ROWTYPE;