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 164: per_contact_relationships pcr

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

Line 175: SELECT contact_person_id from PER_CONTACT_RELATIONSHIPS

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

Line 179: SELECT 1 from per_contact_relationships

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

Line 340: per_contact_relationships pcr

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

Line 346: SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS

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

Line 351: SELECT person_id from PER_CONTACT_RELATIONSHIPS

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

Line 504: per_contact_relationships pcr

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

Line 510: SELECT contact_relationship_id from PER_CONTACT_RELATIONSHIPS

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

Line 515: SELECT person_id from PER_CONTACT_RELATIONSHIPS

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