DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_FSCL_QTR

Line 1762: SELECT DDR_R_FSCL_QTR_SEQ.NEXTVAL

1758: l_qtr_no := l_qtr_no + 1;
1759: l_curr_qtr_start_date := l_curr_date;
1760: l_curr_qtr_end_date := ADD_MONTHS(l_curr_qtr_start_date,3)-1;
1761: -- l_curr_qtr_id := TO_NUMBER(TO_CHAR(l_curr_qtr_start_date,g_QTR_ID_format));
1762: SELECT DDR_R_FSCL_QTR_SEQ.NEXTVAL
1763: INTO l_curr_qtr_id
1764: FROM DUAL;
1765: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
1766:

Line 1767: insert into DDR_R_FSCL_QTR (

1763: INTO l_curr_qtr_id
1764: FROM DUAL;
1765: l_curr_qtr := TO_NUMBER(TO_CHAR(l_curr_year) || TO_CHAR(l_qtr_no));
1766:
1767: insert into DDR_R_FSCL_QTR (
1768: FSCL_QTR_ID,
1769: MFG_ORG_CD,
1770: CLNDR_CD,
1771: QTR_CD,