APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on PER_ALL_PEOPLE_F

Line 7702: PER_ALL_PEOPLE_F PAP

7698: x_contact_details.state,
7699: x_contact_details.country,
7700: x_contact_details.email
7701: FROM CSI_I_PARTIES CIP,
7702: PER_ALL_PEOPLE_F PAP
7703: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7704: AND CIP.PARTY_ID = PAP.PERSON_ID
7705: AND PAP.EFFECTIVE_START_DATE <= SYSDATE
7706: AND PAP.EFFECTIVE_END_DATE >= SYSDATE

Line 8165: FROM per_all_people_f

8161: SELECT employee_number,
8162: 'EMPLYOEE'
8163: INTO x_party_history_tbl(i).old_contact_party_number,
8164: x_party_history_tbl(i).old_contact_party_type
8165: FROM per_all_people_f
8166: WHERE person_id = l_old_contact_party_id
8167: AND rownum < 2; -- Bug # 2183107 srramakr
8168: EXCEPTION
8169: WHEN OTHERS THEN

Line 8246: FROM per_all_people_f

8242: full_name
8243: INTO x_party_history_tbl(i).old_party_number,
8244: x_party_history_tbl(i).old_party_type,
8245: x_party_history_tbl(i).old_party_name
8246: FROM per_all_people_f
8247: WHERE person_id = x_party_history_tbl(i).old_party_id
8248: AND rownum < 2; -- Bug # 2183107 srramakr
8249: EXCEPTION
8250: WHEN OTHERS THEN

Line 8357: FROM per_all_people_f

8353: SELECT employee_number,
8354: 'EMPLYOEE'
8355: INTO x_party_history_tbl(i).new_contact_party_number,
8356: x_party_history_tbl(i).new_contact_party_type
8357: FROM per_all_people_f
8358: WHERE person_id = l_new_contact_party_id
8359: AND rownum < 2; -- Bug # 2183107 srramakr
8360: EXCEPTION
8361: WHEN OTHERS THEN

Line 8439: FROM per_all_people_f

8435: full_name
8436: INTO x_party_history_tbl(i).new_party_number,
8437: x_party_history_tbl(i).new_party_type,
8438: x_party_history_tbl(i).new_party_name
8439: FROM per_all_people_f
8440: WHERE person_id = x_party_history_tbl(i).new_party_id
8441: AND rownum < 2; -- Bug # 2183107 srramakr
8442: EXCEPTION
8443: WHEN OTHERS THEN