DBA Data[Home] [Help]

APPS.DDR_POP_CALENDAR_PKG dependencies on DDR_R_BSNS_MNTH

Line 1418: SELECT DDR_R_BSNS_MNTH_SEQ.NEXTVAL

1414: END IF;
1415:
1416: l_curr_month_end_date := l_curr_month_start_date + 7*l_no_of_weeks_month - 1;
1417: -- l_curr_month_id := TO_NUMBER(TO_CHAR(l_curr_month_start_date,g_MNTH_ID_format));
1418: SELECT DDR_R_BSNS_MNTH_SEQ.NEXTVAL
1419: INTO l_curr_month_id
1420: FROM DUAL;
1421: l_curr_month := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_month_no),2,'0'));
1422:

Line 1423: insert into DDR_R_BSNS_MNTH (

1419: INTO l_curr_month_id
1420: FROM DUAL;
1421: l_curr_month := TO_NUMBER(TO_CHAR(l_curr_year) || LPAD(TO_CHAR(l_month_no),2,'0'));
1422:
1423: insert into DDR_R_BSNS_MNTH (
1424: BSNS_MNTH_ID,
1425: MFG_ORG_CD,
1426: CLNDR_CD,
1427: MNTH_CD,