DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on BOM_CALENDAR_DATES

Line 5326: from bom_calendar_dates bcd,

5322: c_exception_set_id number,
5323: c_calendar_date date,
5324: c_lead_time number) IS
5325: select bcd1.calendar_date
5326: from bom_calendar_dates bcd,
5327: bom_calendar_dates bcd1
5328: where bcd.calendar_code = c_calendar_code
5329: and bcd.exception_set_id = c_exception_set_id
5330: and bcd.calendar_date = c_calendar_date

Line 5327: bom_calendar_dates bcd1

5323: c_calendar_date date,
5324: c_lead_time number) IS
5325: select bcd1.calendar_date
5326: from bom_calendar_dates bcd,
5327: bom_calendar_dates bcd1
5328: where bcd.calendar_code = c_calendar_code
5329: and bcd.exception_set_id = c_exception_set_id
5330: and bcd.calendar_date = c_calendar_date
5331: and bcd1.calendar_code = bcd.calendar_code

Line 5340: from bom_calendar_dates bcd

5336: c_exception_set_id number,
5337: c_calendar_date date)
5338: IS
5339: select bcd.seq_num
5340: from bom_calendar_dates bcd
5341: where bcd.calendar_code = c_calendar_code
5342: and bcd.exception_set_id = c_exception_set_id
5343: and bcd.calendar_date = c_calendar_date;
5344:

Line 5403: from bom_calendar_dates bcd,

5399: c_exception_set_id number,
5400: c_calendar_date date,
5401: c_lead_time number) IS
5402: select bcd1.calendar_date
5403: from bom_calendar_dates bcd,
5404: bom_calendar_dates bcd1
5405: where bcd.calendar_code = c_calendar_code
5406: and bcd.exception_set_id = c_exception_set_id
5407: and bcd.calendar_date = c_calendar_date

Line 5404: bom_calendar_dates bcd1

5400: c_calendar_date date,
5401: c_lead_time number) IS
5402: select bcd1.calendar_date
5403: from bom_calendar_dates bcd,
5404: bom_calendar_dates bcd1
5405: where bcd.calendar_code = c_calendar_code
5406: and bcd.exception_set_id = c_exception_set_id
5407: and bcd.calendar_date = c_calendar_date
5408: and bcd1.calendar_code = bcd.calendar_code

Line 5417: from bom_calendar_dates bcd

5413: c_exception_set_id number,
5414: c_calendar_date date)
5415: IS
5416: select bcd.seq_num
5417: from bom_calendar_dates bcd
5418: where bcd.calendar_code = c_calendar_code
5419: and bcd.exception_set_id = c_exception_set_id
5420: and bcd.calendar_date = c_calendar_date;
5421: