APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_ADVR_QTR

Line 2156: SELECT DDR_R_ADVR_QTR_SEQ.NEXTVAL

2152: END IF;
2153:
2154: l_curr_qtr_end_date := l_curr_qtr_start_date + 7*l_no_of_weeks_qtr - 1;
2155: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
2156: SELECT DDR_R_ADVR_QTR_SEQ.NEXTVAL
2157: INTO l_curr_qtr_id
2158: FROM DUAL;
2159: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
2160:

Line 2161: insert into DDR_R_ADVR_QTR (

2157: INTO l_curr_qtr_id
2158: FROM DUAL;
2159: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
2160:
2161: insert into DDR_R_ADVR_QTR (
2162: ADVR_QTR_ID,
2163: MFG_ORG_CD,
2164: CLNDR_CD,
2165: QTR_CD,