DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on HZ_CUST_SITE_USES_ALL

Line 1067: FROM hz_cust_site_uses_all

1063: WHERE hr.location_id = p_location_id;
1064:
1065: CURSOR c_location(p_site_use_id NUMBER) IS
1066: SELECT location
1067: FROM hz_cust_site_uses_all
1068: WHERE site_use_id = p_site_use_id;
1069:
1070: CURSOR c_phone_fax(p_location_id NUMBER, p_type VARCHAR2) IS
1071: SELECT hcp.phone_country_code||decode(hcp.phone_country_code, NULL, '',' ')||