67: BEGIN
68:
69: SELECT count(*)
70: INTO P_COUNT
71: FROM org_freight ofg
72: WHERE ofg.description = P_DESCRIPTION and
73: -- ofg.organization_id = P_ORGANIZATION_ID and
74: nvl(ofg.disable_date, sysdate) <= sysdate;
75:
75:
76: IF (P_COUNT = 1) THEN
77: SELECT FREIGHT_CODE
78: INTO P_FREIGHT_CARRIER_CODE
79: FROM org_freight ofg
80: WHERE ofg.description = P_DESCRIPTION and
81: -- ofg.organization_id = P_ORGANIZATION_ID and
82: nvl(ofg.disable_date, sysdate) <= sysdate;
83: END IF;