DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_PLNG_QTR

Line 2621: SELECT DDR_R_PLNG_QTR_SEQ.NEXTVAL

2617: END IF;
2618:
2619: l_curr_qtr_end_date := l_curr_qtr_start_date + 7*l_no_of_weeks_qtr - 1;
2620: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
2621: SELECT DDR_R_PLNG_QTR_SEQ.NEXTVAL
2622: INTO l_curr_qtr_id
2623: FROM DUAL;
2624: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
2625:

Line 2626: insert into DDR_R_PLNG_QTR (

2622: INTO l_curr_qtr_id
2623: FROM DUAL;
2624: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
2625:
2626: insert into DDR_R_PLNG_QTR (
2627: PLNG_QTR_ID,
2628: MFG_ORG_CD,
2629: CLNDR_CD,
2630: QTR_CD,