DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_XML_HZ_ADDR_1_0_V

Line 3702: FROM IBY_XML_HZ_ADDR_1_0_V

3698: l_hz_addr XMLTYPE;
3699:
3700: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS
3701: SELECT address
3702: FROM IBY_XML_HZ_ADDR_1_0_V
3703: WHERE location_id = p_location_id;
3704:
3705:
3706: BEGIN

Line 3744: FROM IBY_XML_HZ_ADDR_1_0_V

3740: l_hz_addr XMLTYPE;
3741:
3742: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS
3743: SELECT address
3744: FROM IBY_XML_HZ_ADDR_1_0_V
3745: WHERE location_id = p_location_id;
3746:
3747:
3748: CURSOR l_country_csr (p_country IN VARCHAR2) IS