APPS.MST_SNAPSHOT_TASK_UTIL dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 29: from wsh_calendar_assignments assg

25: and rownum = 1;
26:
27: cursor hr_Calendar(lownerId in number) is
28: select assg.CALENDAR_CODE
29: from wsh_calendar_assignments assg
30: WHERE
31: CALENDAR_TYPE = lCalendarType --'SHIPPING' or 'RECEIVING'
32: AND ( (assg.LOCATION_ID = lLocationId AND
33: ASSOCIATION_TYPE = 'HR_LOCATION') OR

Line 41: from wsh_calendar_assignments assg

37: Order By assg.LOCATION_ID;
38:
39: cursor cust_loc_calendar (lCustId in number) is
40: select assg.CALENDAR_CODE
41: from wsh_calendar_assignments assg
42: WHERE assg.LOCATION_ID = lLocationId
43: AND CALENDAR_TYPE = lCalendarType --'SHIPPING' or 'RECEIVING'
44: AND ASSOCIATION_TYPE = 'CUSTOMER_SITE';
45:

Line 48: from wsh_calendar_assignments assg

44: AND ASSOCIATION_TYPE = 'CUSTOMER_SITE';
45:
46: cursor cust_calendar(lCustId in number) is
47: select assg.CALENDAR_CODE
48: from wsh_calendar_assignments assg
49: WHERE assg.CUSTOMER_ID = lCustId
50: AND CALENDAR_TYPE = lCalendarType --'SHIPPING' or 'RECEIVING'
51: AND ASSOCIATION_TYPE = 'CUSTOMER';
52:

Line 55: from wsh_calendar_assignments assg

51: AND ASSOCIATION_TYPE = 'CUSTOMER';
52:
53: cursor car_loc_calendar(lCarrierId in number) is
54: select assg.CALENDAR_CODE
55: from wsh_calendar_assignments assg
56: WHERE assg.LOCATION_ID = lLocationId
57: AND assg.carrier_id = lCarrierId
58: AND CALENDAR_TYPE = lCalendarType --'SHIPPING' or 'RECEIVING'
59: AND ASSOCIATION_TYPE = 'CARRIER_SITE';

Line 63: from wsh_calendar_assignments assg

59: AND ASSOCIATION_TYPE = 'CARRIER_SITE';
60:
61: cursor car_calendar(lCarrier_id in number) is
62: select assg.CALENDAR_CODE
63: from wsh_calendar_assignments assg
64: WHERE
65: assg.carrier_id = lCarrier_id
66: AND CALENDAR_TYPE = lCalendarType --'SHIPPING' or 'RECEIVING'
67: AND ASSOCIATION_TYPE = 'CARRIER';

Line 71: from wsh_calendar_assignments assg

67: AND ASSOCIATION_TYPE = 'CARRIER';
68:
69: cursor sup_loc_calendar(lSupplierId in number) is
70: select assg.CALENDAR_CODE
71: from wsh_calendar_assignments assg
72: WHERE assg.LOCATION_ID = lLocationId
73: AND assg.VENDOR_ID = lSupplierId
74: AND assg.CALENDAR_TYPE = lCalendarType
75: AND assg.ASSOCIATION_TYPE = 'VENDOR_SITE';

Line 79: from wsh_calendar_assignments assg

75: AND assg.ASSOCIATION_TYPE = 'VENDOR_SITE';
76:
77: cursor sup_calendar(lSupplierId in number) is
78: select assg.CALENDAR_CODE
79: from wsh_calendar_assignments assg
80: WHERE assg.VENDOR_ID = lSupplierId
81: AND assg.CALENDAR_TYPE = lCalendarType
82: AND assg.ASSOCIATION_TYPE = 'VENDOR';
83: