APPS.PAY_JP_DEF_SS dependencies on PER_CONTACT_RELATIONSHIPS

Line 1598: from per_contact_relationships ctr

1594: is
1595: select ctr.contact_relationship_id,
1596: ctr.contact_person_id,
1597: ctr.contact_type
1598: from per_contact_relationships ctr
1599: where ctr.person_id = p_person_id
1600: and ctr.cont_information3 = 'Y'
1601: and p_effective_date
1602: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date);

Line 1610: from per_contact_relationships ctr

1606: select 'Y' married_flag
1607: from dual
1608: where exists(
1609: select null
1610: from per_contact_relationships ctr
1611: where ctr.person_id = p_person_id
1612: and ctr.contact_type = 'S'
1613: and p_effective_date
1614: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date));

Line 1639: from per_contact_relationships ctr,

1635: cei.cei_information2 OCCUPATION,
1636: fnd_number.canonical_to_number(cei.cei_information3) ESTIMATED_ANNUAL_INCOME,
1637: cei.cei_information6 DISABILITY_TYPE,
1638: cei.cei_information7 DISABILITY_DETAILS
1639: from per_contact_relationships ctr,
1640: per_contact_extra_info_f cei,
1641: per_addresses adrr,
1642: per_addresses adrc,
1643: per_all_people_f per

Line 1693: from per_contact_relationships ctr,

1689: ctr2.contact_type OE_CONTACT_TYPE,
1690: trim(substrb(decode(adrr2.address_id, null,
1691: adrc2.address_line1 || adrc2.address_line2 || adrc2.address_line3,
1692: adrr2.address_line1 || adrr2.address_line2 || adrr2.address_line3), 1, 240)) OE_ADDRESS
1693: from per_contact_relationships ctr,
1694: per_contact_extra_info_f cei,
1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,

Line 1698: per_contact_relationships ctr2,

1694: per_contact_extra_info_f cei,
1695: per_addresses adrr,
1696: per_addresses adrc,
1697: per_all_people_f per,
1698: per_contact_relationships ctr2,
1699: per_addresses adrr2,
1700: per_addresses adrc2
1701: where ctr.person_id = p_person_id
1702: and cei.contact_relationship_id = ctr.contact_relationship_id

Line 1752: per_contact_relationships ctr

1748: cei.cei_information2 OS_SALARY_PAYER_NAME,
1749: cei.cei_information3 OS_SALARY_PAYER_ADDRESS
1750: from per_all_people_f per,
1751: per_contact_extra_info_f cei,
1752: per_contact_relationships ctr
1753: where ctr.person_id = p_person_id
1754: and cei.contact_relationship_id = ctr.contact_relationship_id
1755: and cei.cei_information_category = 'JP_ITAX_DEPENDENT_ON_OTHER_PAY'
1756: and p_effective_date