APPS.IBY_VALIDATIONSETS_PUB dependencies on HR_LOCATIONS

Line 109: * possible sources: HR_LOCATIONS, PER_ADDRESSES

105: /*
106: * Fix for bug 6713003:
107: *
108: * The payee address fields are picked up from three
109: * possible sources: HR_LOCATIONS, PER_ADDRESSES
110: * and HZ_LOCATIONS. Therefore, the field sizes
111: * should be the maximum of the corresponding column
112: * sizes from these three tables.
113: *

Line 115: * But for state, county and provice fields, HR_LOCATIONS /

111: * should be the maximum of the corresponding column
112: * sizes from these three tables.
113: *
114: * Usually, HZ_LOCATIONS field sizes are sufficient.
115: * But for state, county and provice fields, HR_LOCATIONS /
116: * PER_ADDRESSES has larger field sizes.
117: *
118: * Therefore, for these three fields, we use HR_LOCATIONS
119: * for the field sizes.

Line 118: * Therefore, for these three fields, we use HR_LOCATIONS

114: * Usually, HZ_LOCATIONS field sizes are sufficient.
115: * But for state, county and provice fields, HR_LOCATIONS /
116: * PER_ADDRESSES has larger field sizes.
117: *
118: * Therefore, for these three fields, we use HR_LOCATIONS
119: * for the field sizes.
120: */
121: payee_party_state HR_LOCATIONS.region_2%TYPE,
122: payee_party_province HR_LOCATIONS.region_1%TYPE,

Line 121: payee_party_state HR_LOCATIONS.region_2%TYPE,

117: *
118: * Therefore, for these three fields, we use HR_LOCATIONS
119: * for the field sizes.
120: */
121: payee_party_state HR_LOCATIONS.region_2%TYPE,
122: payee_party_province HR_LOCATIONS.region_1%TYPE,
123: payee_party_county HR_LOCATIONS.region_1%TYPE,
124:
125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,

Line 122: payee_party_province HR_LOCATIONS.region_1%TYPE,

118: * Therefore, for these three fields, we use HR_LOCATIONS
119: * for the field sizes.
120: */
121: payee_party_state HR_LOCATIONS.region_2%TYPE,
122: payee_party_province HR_LOCATIONS.region_1%TYPE,
123: payee_party_county HR_LOCATIONS.region_1%TYPE,
124:
125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
126: payee_party_country HZ_LOCATIONS.country%TYPE,

Line 123: payee_party_county HR_LOCATIONS.region_1%TYPE,

119: * for the field sizes.
120: */
121: payee_party_state HR_LOCATIONS.region_2%TYPE,
122: payee_party_province HR_LOCATIONS.region_1%TYPE,
123: payee_party_county HR_LOCATIONS.region_1%TYPE,
124:
125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
126: payee_party_country HZ_LOCATIONS.country%TYPE,
127: