DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on FND_TERRITORIES

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

697: END validate_app_id;
698:
699:
700: FUNCTION validate_territory
701: ( p_territory IN fnd_territories.territory_code%TYPE )
702: RETURN BOOLEAN
703: IS
704:
705: l_territory fnd_territories.territory_code%TYPE;

Line 705: l_territory fnd_territories.territory_code%TYPE;

701: ( p_territory IN fnd_territories.territory_code%TYPE )
702: RETURN BOOLEAN
703: IS
704:
705: l_territory fnd_territories.territory_code%TYPE;
706:
707: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
708: IS
709: SELECT territory_code

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

703: IS
704:
705: l_territory fnd_territories.territory_code%TYPE;
706:
707: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
708: IS
709: SELECT territory_code
710: FROM fnd_territories
711: WHERE (territory_code = ci_code)

Line 710: FROM fnd_territories

706:
707: CURSOR c_terr( ci_code IN fnd_territories.territory_code%TYPE )
708: IS
709: SELECT territory_code
710: FROM fnd_territories
711: WHERE (territory_code = ci_code)
712: AND (NVL(obsolete_flag,'N') = 'N');
713:
714: BEGIN