APPS.WIP_CALENDAR dependencies on MTL_PARAMETERS

Line 30: MTL_PARAMETERS MP

26: cursor cursor_forward is
27: SELECT BCD1.CALENDAR_DATE
28: FROM BOM_CALENDAR_DATES BCD1,
29: BOM_CALENDAR_DATES BCD2,
30: MTL_PARAMETERS MP
31: WHERE MP.ORGANIZATION_ID = x_org_id
32: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
33: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
34: AND BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID

Line 43: MTL_PARAMETERS MP

39: cursor cursor_backward is
40: SELECT BCD1.CALENDAR_DATE
41: FROM BOM_CALENDAR_DATES BCD1,
42: BOM_CALENDAR_DATES BCD2,
43: MTL_PARAMETERS MP
44: WHERE MP.ORGANIZATION_ID = x_org_id
45: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
46: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
47: AND BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID

Line 60: MTL_PARAMETERS MP

56: */
57: cursor cursor_working_day is
58: SELECT nvl(BCD.SEQ_NUM,-1)
59: FROM BOM_CALENDAR_DATES BCD,
60: MTL_PARAMETERS MP
61: WHERE MP.ORGANIZATION_ID = x_org_id
62: AND BCD.CALENDAR_CODE = MP.CALENDAR_CODE
63: AND BCD.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
64: AND BCD.CALENDAR_DATE = TRUNC(x_sched_date);