DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on FND_TERRITORIES

Line 726: ( p_territory IN fnd_territories.territory_code%TYPE )

722: END validate_app_id;
723:
724:
725: FUNCTION validate_territory
726: ( p_territory IN fnd_territories.territory_code%TYPE )
727: RETURN BOOLEAN
728: IS
729:
730: l_territory fnd_territories.territory_code%TYPE;

Line 730: l_territory fnd_territories.territory_code%TYPE;

726: ( p_territory IN fnd_territories.territory_code%TYPE )
727: RETURN BOOLEAN
728: IS
729:
730: l_territory fnd_territories.territory_code%TYPE;
731:
732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
733: IS
734: SELECT territory_code

Line 732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )

728: IS
729:
730: l_territory fnd_territories.territory_code%TYPE;
731:
732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
733: IS
734: SELECT territory_code
735: FROM fnd_territories
736: WHERE (territory_code = ci_code)

Line 735: FROM fnd_territories

731:
732: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
733: IS
734: SELECT territory_code
735: FROM fnd_territories
736: WHERE (territory_code = ci_code)
737: AND (NVL(obsolete_flag,'N') = 'N');
738:
739: BEGIN