APPS.CSP_SCH_INT_PVT dependencies on CSP_CARRIER_DELIVERY_TIMES

Line 5310: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

5306: CURSOR csp_ship_methodes(from_org varchar2,to_org varchar2) IS
5307: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0)
5308: ,CDT.FREIGHT_CODE,CDT.LEAD_TIME,CDT.LEAD_TIME_UOM,CDT.DELIVERY_TIME
5309: ,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,CDT.SAFETY_ZONE
5310: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
5311: WHERE ISM.FROM_ORGANIZATION_ID = from_org
5312: AND ISM.TO_ORGANIZATION_ID = to_org
5313: AND CDT.ORGANIZATION_ID = from_org
5314: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;

Line 5659: FROM CSP_CARRIER_DELIVERY_TIMES CDT

5655: x_msg_count OUT NOCOPY NUMBER) IS
5656: CURSOR C1(c_relation_id NUMBER) IS
5657: SELECT CDT.LEAD_TIME,CDT.LEAD_TIME_UOM,CDT.DELIVERY_TIME
5658: ,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,CDT.SAFETY_ZONE
5659: FROM CSP_CARRIER_DELIVERY_TIMES CDT
5660: WHERE CDT.relation_ship_id = c_relation_id;
5661: I NUMBER;
5662: l_hours NUMBER;
5663: l_days NUMBER;

Line 6031: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

6027: ,x_msg_count OUT NOCOPY NUMBER) IS
6028: CURSOR C3(from_org varchar2,to_org varchar2) IS
6029: SELECT NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
6030: CDT.RELATION_SHIP_ID,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,ISM.SHIP_METHOD
6031: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
6032: WHERE ISM.FROM_ORGANIZATION_ID = from_org
6033: AND ISM.TO_ORGANIZATION_ID = to_org
6034: AND CDT.ORGANIZATION_ID = from_org
6035: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;

Line 7967: from CSP_CARRIER_DELIVERY_TIMES

7963:
7964: cursor get_cutoff_time(c_org_id number,
7965: c_ship_method_code varchar2) IS
7966: select cutoff_time,timezone_id
7967: from CSP_CARRIER_DELIVERY_TIMES
7968: where ORGANIZATION_ID = c_org_id
7969: and SHIPPING_METHOD = c_ship_method_code;
7970:
7971: BEGIN