eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IN_CON_LEG_HOOK dependencies on PER_CONTACT_RELATIONSHIPS

Line 163: per_contact_relationships pcr

159: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
160:
161: SELECT pbg.legislation_code
162: FROM per_business_groups pbg,
163: per_contact_relationships pcr
164: WHERE pcr.contact_relationship_id = p_contact_relationship_id
165: AND pcr.business_group_id = pbg.business_group_id;
166:
167: CURSOR c_get_birth_date(l_contact_person_id IN NUMBER) IS

Line 174: SELECT contact_person_id from PER_CONTACT_RELATIONSHIPS

170: WHERE PERSON_ID = l_contact_person_id ;
171:
172: CURSOR c_get_contact_person_id IS
173:
174: SELECT contact_person_id from PER_CONTACT_RELATIONSHIPS
175: WHERE contact_relationship_id = p_contact_relationship_id;
176:
177: CURSOR c_check_guardian_details IS
178: SELECT 1 from per_contact_relationships

Line 178: SELECT 1 from per_contact_relationships

174: SELECT contact_person_id from PER_CONTACT_RELATIONSHIPS
175: WHERE contact_relationship_id = p_contact_relationship_id;
176:
177: CURSOR c_check_guardian_details IS
178: SELECT 1 from per_contact_relationships
179: WHERE contact_relationship_id = p_contact_relationship_id
180: AND cont_information13 is not null
181: AND cont_information14 is not null
182: AND cont_information15 is not null

Line 338: per_contact_relationships pcr

334: CURSOR c_business_group_check
335: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
336: SELECT pbg.legislation_code
337: FROM per_business_groups pbg,
338: per_contact_relationships pcr
339: WHERE pcr.contact_relationship_id = p_contact_relationship_id
340: AND pcr.business_group_id = pbg.business_group_id;
341:
342:

Line 344: SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS

340: AND pcr.business_group_id = pbg.business_group_id;
341:
342:
343: CURSOR c_get_relationship_id(l_person_id IN NUMBER) IS
344: SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS
345: WHERE person_id = l_person_id
346: AND contact_relationship_id <> p_contact_relationship_id;
347:
348: CURSOR c_get_person_id IS

Line 349: SELECT person_id from PER_CONTACT_RELATIONSHIPS

345: WHERE person_id = l_person_id
346: AND contact_relationship_id <> p_contact_relationship_id;
347:
348: CURSOR c_get_person_id IS
349: SELECT person_id from PER_CONTACT_RELATIONSHIPS
350: WHERE contact_relationship_id = p_contact_relationship_id;
351:
352: CURSOR c_check_benefit IS
353: SELECT 1 from PER_CONTACT_EXTRA_INFO_F

Line 502: per_contact_relationships pcr

498: CURSOR c_business_group_check
499: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
500: SELECT pbg.legislation_code
501: FROM per_business_groups pbg,
502: per_contact_relationships pcr
503: WHERE pcr.contact_relationship_id = p_contact_relationship_id
504: AND pcr.business_group_id = pbg.business_group_id;
505:
506:

Line 508: SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS

504: AND pcr.business_group_id = pbg.business_group_id;
505:
506:
507: CURSOR c_get_relationship_id(l_person_id IN NUMBER) IS
508: SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS
509: WHERE person_id = l_person_id
510: AND contact_relationship_id <> p_contact_relationship_id;
511:
512: CURSOR c_get_person_id IS

Line 513: SELECT person_id from PER_CONTACT_RELATIONSHIPS

509: WHERE person_id = l_person_id
510: AND contact_relationship_id <> p_contact_relationship_id;
511:
512: CURSOR c_get_person_id IS
513: SELECT person_id from PER_CONTACT_RELATIONSHIPS
514: WHERE contact_relationship_id = p_contact_relationship_id;
515:
516:
517: BEGIN