APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on PER_ALL_PEOPLE_F

Line 7652: PER_ALL_PEOPLE_F PAP

7648: x_contact_details.state,
7649: x_contact_details.country,
7650: x_contact_details.email
7651: FROM CSI_I_PARTIES CIP,
7652: PER_ALL_PEOPLE_F PAP
7653: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7654: AND CIP.PARTY_ID = PAP.PERSON_ID
7655: AND PAP.EFFECTIVE_START_DATE <= SYSDATE
7656: AND PAP.EFFECTIVE_END_DATE >= SYSDATE

Line 8115: FROM per_all_people_f

8111: SELECT employee_number,
8112: 'EMPLYOEE'
8113: INTO x_party_history_tbl(i).old_contact_party_number,
8114: x_party_history_tbl(i).old_contact_party_type
8115: FROM per_all_people_f
8116: WHERE person_id = l_old_contact_party_id
8117: AND rownum < 2; -- Bug # 2183107 srramakr
8118: EXCEPTION
8119: WHEN OTHERS THEN

Line 8196: FROM per_all_people_f

8192: full_name
8193: INTO x_party_history_tbl(i).old_party_number,
8194: x_party_history_tbl(i).old_party_type,
8195: x_party_history_tbl(i).old_party_name
8196: FROM per_all_people_f
8197: WHERE person_id = x_party_history_tbl(i).old_party_id
8198: AND rownum < 2; -- Bug # 2183107 srramakr
8199: EXCEPTION
8200: WHEN OTHERS THEN

Line 8307: FROM per_all_people_f

8303: SELECT employee_number,
8304: 'EMPLYOEE'
8305: INTO x_party_history_tbl(i).new_contact_party_number,
8306: x_party_history_tbl(i).new_contact_party_type
8307: FROM per_all_people_f
8308: WHERE person_id = l_new_contact_party_id
8309: AND rownum < 2; -- Bug # 2183107 srramakr
8310: EXCEPTION
8311: WHEN OTHERS THEN

Line 8389: FROM per_all_people_f

8385: full_name
8386: INTO x_party_history_tbl(i).new_party_number,
8387: x_party_history_tbl(i).new_party_type,
8388: x_party_history_tbl(i).new_party_name
8389: FROM per_all_people_f
8390: WHERE person_id = x_party_history_tbl(i).new_party_id
8391: AND rownum < 2; -- Bug # 2183107 srramakr
8392: EXCEPTION
8393: WHEN OTHERS THEN