APPS.PAY_AE_SI_REPORTS dependencies on PER_CONTACT_RELATIONSHIPS

Line 281: FROM per_contact_relationships cont

277:
278: /* Cursor for fetching person's spouse's person id */
279: CURSOR csr_p_spouse_id (l_person_id number,l_type varchar2, l_gender varchar2,l_effective_date date) IS
280: SELECT CONTACT_PERSON_ID
281: FROM per_contact_relationships cont
282: WHERE cont.person_id = l_person_id
283: AND cont.contact_type = l_type;
284:
285: /* Cursor for fetching person's spouse's qualification details */

Line 299: FROM per_contact_relationships cont , per_all_people_f ppf

295:
296: /* Cursor for fetching person's contact counts */
297: CURSOR csr_p_contact_count_data (l_person_id number,l_type varchar2, l_gender varchar2, l_effective_date date) IS
298: SELECT count(*)
299: FROM per_contact_relationships cont , per_all_people_f ppf
300: WHERE cont.person_id = l_person_id
301: AND cont.contact_type = l_type
302: AND ppf.person_id = cont.CONTACT_PERSON_ID
303: AND ppf.sex = l_gender

Line 1327: FROM per_contact_relationships cont , per_all_people_f ppf

1323:
1324: /* Cursor for fetching person's contact counts */
1325: CURSOR csr_p_contact_count_data (l_person_id number,l_type varchar2, l_gender varchar2, l_effective_date date) IS
1326: SELECT count(*)
1327: FROM per_contact_relationships cont , per_all_people_f ppf
1328: WHERE cont.person_id = l_person_id
1329: AND cont.contact_type = l_type
1330: AND ppf.person_id = cont.CONTACT_PERSON_ID
1331: AND ppf.sex = l_gender