APPS.OKL_OPI_PVT dependencies on HZ_CONTACT_POINTS

Line 49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE

45: ,floor HZ_LOCATIONS.FLOOR%TYPE
46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE
51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE
52: ,phone_extension HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE);
53:

Line 50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE

46: ,suite HZ_LOCATIONS.SUITE%TYPE
47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE
51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE
52: ,phone_extension HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE);
53:
54: TYPE party_tbl_type IS TABLE OF party_rec_type

Line 51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE

47: ,room HZ_LOCATIONS.ROOM%TYPE
48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE
51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE
52: ,phone_extension HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE);
53:
54: TYPE party_tbl_type IS TABLE OF party_rec_type
55: INDEX BY BINARY_INTEGER;

Line 52: ,phone_extension HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE);

48: ,postal_plus4_code HZ_LOCATIONS.POSTAL_PLUS4_CODE%TYPE
49: ,phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE
50: ,phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE
51: ,phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE
52: ,phone_extension HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE);
53:
54: TYPE party_tbl_type IS TABLE OF party_rec_type
55: INDEX BY BINARY_INTEGER;
56: