DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on BOM_CALENDAR_DATES

Line 7868: from bom_calendar_dates bcd,

7864: c_exception_set_id number,
7865: c_calendar_date date,
7866: c_lead_time number) IS
7867: select bcd1.calendar_date
7868: from bom_calendar_dates bcd,
7869: bom_calendar_dates bcd1
7870: where bcd.calendar_code = c_calendar_code
7871: and bcd.exception_set_id = c_exception_set_id
7872: and bcd.calendar_date = c_calendar_date

Line 7869: bom_calendar_dates bcd1

7865: c_calendar_date date,
7866: c_lead_time number) IS
7867: select bcd1.calendar_date
7868: from bom_calendar_dates bcd,
7869: bom_calendar_dates bcd1
7870: where bcd.calendar_code = c_calendar_code
7871: and bcd.exception_set_id = c_exception_set_id
7872: and bcd.calendar_date = c_calendar_date
7873: and bcd1.calendar_code = bcd.calendar_code

Line 7882: from bom_calendar_dates bcd

7878: c_exception_set_id number,
7879: c_calendar_date date)
7880: IS
7881: select bcd.seq_num
7882: from bom_calendar_dates bcd
7883: where bcd.calendar_code = c_calendar_code
7884: and bcd.exception_set_id = c_exception_set_id
7885: and bcd.calendar_date = c_calendar_date;
7886:

Line 7945: from bom_calendar_dates bcd,

7941: c_exception_set_id number,
7942: c_calendar_date date,
7943: c_lead_time number) IS
7944: select bcd1.calendar_date
7945: from bom_calendar_dates bcd,
7946: bom_calendar_dates bcd1
7947: where bcd.calendar_code = c_calendar_code
7948: and bcd.exception_set_id = c_exception_set_id
7949: and bcd.calendar_date = c_calendar_date

Line 7946: bom_calendar_dates bcd1

7942: c_calendar_date date,
7943: c_lead_time number) IS
7944: select bcd1.calendar_date
7945: from bom_calendar_dates bcd,
7946: bom_calendar_dates bcd1
7947: where bcd.calendar_code = c_calendar_code
7948: and bcd.exception_set_id = c_exception_set_id
7949: and bcd.calendar_date = c_calendar_date
7950: and bcd1.calendar_code = bcd.calendar_code

Line 7959: from bom_calendar_dates bcd

7955: c_exception_set_id number,
7956: c_calendar_date date)
7957: IS
7958: select bcd.seq_num
7959: from bom_calendar_dates bcd
7960: where bcd.calendar_code = c_calendar_code
7961: and bcd.exception_set_id = c_exception_set_id
7962: and bcd.calendar_date = c_calendar_date;
7963: