APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_ADVR_PRD

Line 2222: SELECT DDR_R_ADVR_PRD_SEQ.NEXTVAL

2218: END IF;
2219:
2220: l_curr_period_end_date := l_curr_period_start_date + 7*l_no_of_weeks_period - 1;
2221: -- l_curr_period_id := TO_NUMBER(TO_CHAR(l_curr_period_start_date,g_PRD_ID_format));
2222: SELECT DDR_R_ADVR_PRD_SEQ.NEXTVAL
2223: INTO l_curr_period_id
2224: FROM DUAL;
2225: l_curr_period := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_period_no),2,'0'));
2226:

Line 2227: insert into DDR_R_ADVR_PRD (

2223: INTO l_curr_period_id
2224: FROM DUAL;
2225: l_curr_period := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_period_no),2,'0'));
2226:
2227: insert into DDR_R_ADVR_PRD (
2228: ADVR_PRD_ID,
2229: MFG_ORG_CD,
2230: CLNDR_CD,
2231: PRD_CD,