APPS.PER_REI_BUS dependencies on PER_CONTACT_INFO_TYPES

Line 235: -- per_contact_info_types where active_inactive_flag is 'Y'.

231: -- {Start Of Comments}
232: --
233: -- Description:
234: -- Validates that the contact information type exists in table
235: -- per_contact_info_types where active_inactive_flag is 'Y'.
236: --
237: -- Pre Conditions:
238: -- Data must be existed in table per_contact_info_types.
239: --

Line 238: -- Data must be existed in table per_contact_info_types.

234: -- Validates that the contact information type exists in table
235: -- per_contact_info_types where active_inactive_flag is 'Y'.
236: --
237: -- Pre Conditions:
238: -- Data must be existed in table per_contact_info_types.
239: --
240: -- In Parameters:
241: -- Name Reqd Type Description
242: -- p_information_type Yes VARCHAR2 Contact Information Type

Line 272: from per_contact_info_types

268: cursor csr_information_type is
269: select legislation_code,
270: active_inactive_flag,
271: multiple_occurences_flag
272: from per_contact_info_types
273: where information_type = p_information_type;
274: l_rec csr_information_type%rowtype;
275: l_min_esd date;
276: begin