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_RU_CON_INFO dependencies on PER_CONTACT_RELATIONSHIPS

Line 29: SELECT contact_type,cont_information1 FROM per_contact_relationships

25: P_CONTACT_TYPE VARCHAR2,
26: p_cont_information1 VARCHAR2) IS
27:
28: CURSOR cur_crl IS
29: SELECT contact_type,cont_information1 FROM per_contact_relationships
30: WHERE contact_person_id IN
31: (SELECT contact_person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
32: AND person_id IN (SELECT person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
33: AND contact_relationship_id = p_contact_relationship_id;

Line 31: (SELECT contact_person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)

27:
28: CURSOR cur_crl IS
29: SELECT contact_type,cont_information1 FROM per_contact_relationships
30: WHERE contact_person_id IN
31: (SELECT contact_person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
32: AND person_id IN (SELECT person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
33: AND contact_relationship_id = p_contact_relationship_id;
34:
35:

Line 32: AND person_id IN (SELECT person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)

28: CURSOR cur_crl IS
29: SELECT contact_type,cont_information1 FROM per_contact_relationships
30: WHERE contact_person_id IN
31: (SELECT contact_person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
32: AND person_id IN (SELECT person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
33: AND contact_relationship_id = p_contact_relationship_id;
34:
35:
36: l_contact_type per_contact_relationships.contact_type%TYPE;

Line 36: l_contact_type per_contact_relationships.contact_type%TYPE;

32: AND person_id IN (SELECT person_id FROM per_contact_relationships WHERE contact_relationship_id = p_contact_relationship_id)
33: AND contact_relationship_id = p_contact_relationship_id;
34:
35:
36: l_contact_type per_contact_relationships.contact_type%TYPE;
37: l_info per_contact_relationships.cont_information1%TYPE;
38:
39: BEGIN
40: --

Line 37: l_info per_contact_relationships.cont_information1%TYPE;

33: AND contact_relationship_id = p_contact_relationship_id;
34:
35:
36: l_contact_type per_contact_relationships.contact_type%TYPE;
37: l_info per_contact_relationships.cont_information1%TYPE;
38:
39: BEGIN
40: --
41: -- Added for GSI Bug 5472781