APPS.AP_VENDOR_PUB_PKG dependencies on ORG_FREIGHT

Line 481: FROM org_freight

477: x_valid := TRUE;
478:
479: SELECT nvl(count(freight_code),0)
480: INTO l_dummy
481: FROM org_freight
482: WHERE organization_id = p_inventory_org_id
483: AND nvl(disable_date, sysdate +1 ) > sysdate
484: AND freight_code = p_ship_via_lookup_code;
485:

Line 2639: l_dummy org_freight.freight_code%TYPE;

2635: PROCEDURE Check_Site_Ship_Via(p_ship_via_lookup_code IN VARCHAR2,
2636: p_org_id IN NUMBER,
2637: x_valid OUT NOCOPY BOOLEAN
2638: ) IS
2639: l_dummy org_freight.freight_code%TYPE;
2640:
2641: BEGIN
2642: x_valid := TRUE;
2643:

Line 2646: FROM org_freight FRT, financials_system_params_all FIN

2642: x_valid := TRUE;
2643:
2644: SELECT FRT.freight_code
2645: INTO l_dummy
2646: FROM org_freight FRT, financials_system_params_all FIN
2647: WHERE FRT.organization_id = FIN.inventory_organization_id
2648: AND FIN.org_id = p_org_id
2649: AND nvl(FRT.disable_date, sysdate +1 ) > sysdate
2650: AND FRT.freight_code = p_ship_via_lookup_code;