APPS.HR_RO_CONTACT_REL_VAL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

    select 'x'
    from per_person_types pet
    where pet.system_person_type = 'OTHER'
		and pet.business_group_id  = p_business_group_id
		and pet.person_type_id = p_person_type_id
		and pet.active_flag = 'Y';

Line: 166

 cursor cur_crl is select 1 from per_contact_relationships
	where contact_person_id  = p_contact_person_id
	and  person_id = p_person_id
	and contact_type in ('EC','ES','PR1','PR2','OTH')
        and P_CONTACT_TYPE in ('EC','ES','PR1','PR2','OTH')
	and (date_start >= p_date_start
	OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));

Line: 175

    select date_of_birth from per_all_people_f where person_id = P_CONTACT_PERSON_ID;

Line: 178

	select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/

Line: 237

 PROCEDURE update_ro_contact_rel
    (p_contact_relationship_id IN number
    ,p_date_start              IN date
    ,p_date_end                IN date
    ,p_contact_type            IN varchar2) IS

  cursor cur_crl is select 1 from per_contact_relationships
	where contact_person_id in
       (select contact_person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
	and  person_id in (select person_id from per_contact_relationships where contact_relationship_id = p_contact_relationship_id)
	and  contact_relationship_id <> p_contact_relationship_id
	and contact_type in ('EC','ES','PR1','PR2','OTH')
        and P_CONTACT_TYPE in ('EC','ES','PR1','PR2','OTH')
	and (date_start >= p_date_start
	OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));

Line: 254

	select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
	per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);

Line: 258

	select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/

Line: 266

l_proc:=g_package||'UPDATE_RO_CONTACT_REL';

Line: 302

END UPDATE_RO_CONTACT_REL;