APPS.PAY_JP_DEF_SS dependencies on PER_CONTACT_RELATIONSHIPS

Line 1308: from per_contact_relationships ctr

1304: p_effective_date date) is
1305: select ctr.contact_relationship_id,
1306: ctr.contact_person_id,
1307: ctr.contact_type
1308: from per_contact_relationships ctr
1309: where ctr.person_id = p_person_id
1310: and ctr.cont_information3 = 'Y'
1311: and p_effective_date
1312: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date);

Line 1320: from per_contact_relationships ctr

1316: select 'Y'
1317: from dual
1318: where exists(
1319: select null
1320: from per_contact_relationships ctr
1321: where ctr.person_id = p_person_id
1322: and ctr.contact_type = 'S'
1323: and p_effective_date
1324: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date));

Line 1380: per_contact_relationships ctr

1376: from per_all_people_f per,
1377: per_addresses adrc,
1378: per_addresses adrr,
1379: per_contact_extra_info_f cei,
1380: per_contact_relationships ctr
1381: where ctr.person_id = p_person_id
1382: and cei.contact_relationship_id = ctr.contact_relationship_id
1383: and cei.cei_information_category = 'JP_ITAX_DEPENDENT'
1384: and p_effective_date

Line 1433: per_contact_relationships ctr2,

1429: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240))
1430: OE_ADDRESS
1431: from per_addresses adrc2,
1432: per_addresses adrr2,
1433: per_contact_relationships ctr2,
1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,
1437: per_contact_extra_info_f cei,

Line 1438: per_contact_relationships ctr

1434: per_all_people_f per,
1435: per_addresses adrc,
1436: per_addresses adrr,
1437: per_contact_extra_info_f cei,
1438: per_contact_relationships ctr
1439: where ctr.person_id = p_person_id
1440: and cei.contact_relationship_id = ctr.contact_relationship_id
1441: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_EMP'
1442: and p_effective_date

Line 1490: per_contact_relationships ctr

1486: cei.cei_information2 OS_SALARY_PAYER_NAME,
1487: cei.cei_information3 OS_SALARY_PAYER_ADDRESS
1488: from per_all_people_f per,
1489: per_contact_extra_info_f cei,
1490: per_contact_relationships ctr
1491: where ctr.person_id = p_person_id
1492: and cei.contact_relationship_id = ctr.contact_relationship_id
1493: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
1494: and p_effective_date