APPS.HR_RO_CONTACT_REL_VAL dependencies on PER_PERSON_TYPES

Line 22: from per_person_types pet

18: l_valid_ni NUMBER DEFAULT 10;
19: l_exist varchar2(1);
20: cursor csr_person_type is
21: select 'x'
22: from per_person_types pet
23: where pet.system_person_type = 'OTHER'
24: and pet.business_group_id = p_business_group_id
25: and pet.person_type_id = p_person_type_id
26: and pet.active_flag = 'Y';

Line 114: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;

110: ,p_per_information1 VARCHAR2-- residence
111: ,p_per_information2 VARCHAR2 -- citizenship
112: ) IS
113: l_proc VARCHAR2(72);
114: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
115: l_valid_ni NUMBER DEFAULT 10;
116: BEGIN
117: l_proc := g_package||'CREATE_RO_CONTACT_PERSON';
118: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

Line 178: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/

174: cursor csr_dob_contact is
175: select date_of_birth from per_all_people_f where person_id = P_CONTACT_PERSON_ID;
176:
177: /*cursor csr_person_type is
178: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/
179:
180: nDummy_val number;
181: l_dob_contact per_all_people_f.date_of_birth%TYPE;
182: l_valid_ni NUMBER DEFAULT 10;

Line 258: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/

254: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
255: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);
256:
257: /* cursor csr_person_type is
258: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/
259:
260: l_contact_dob per_all_people_f.date_of_birth%TYPE;
261: nDummy_val number;
262: l_valid_ni NUMBER DEFAULT 10;