APPS.PAY_JP_REPORT_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 1418: per_contact_extra_info_f pceif,

1414: DECODE(pceif.cei_information6,
1415: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),
1416: '30', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER'), NULL) || ')',1,2000)) details
1417: FROM per_contact_relationships pcr,
1418: per_contact_extra_info_f pceif,
1419: per_all_people_f papf
1420: WHERE pcr.person_id = p_person_id
1421: AND pcr.cont_information_category = 'JP'
1422: AND pcr.cont_information1 = 'Y'

Line 1486: per_contact_extra_info_f pceif

1482: WHERE EXISTS(
1483: SELECT /*+ ORDERED */
1484: NULL
1485: FROM per_contact_relationships pcr,
1486: per_contact_extra_info_f pceif
1487: WHERE pcr.person_id = p_person_id
1488: AND pcr.cont_information_category = 'JP'
1489: AND pcr.cont_information1 = 'Y'
1490: AND p_effective_date

Line 1585: from per_contact_extra_info_f pceif

1581: and p_effective_date
1582: between nvl(pcr.date_start, p_effective_date) and nvl(pcr.date_end, p_effective_date)
1583: and exists(
1584: select null
1585: from per_contact_extra_info_f pceif
1586: where pceif.contact_relationship_id = pcr.contact_relationship_id
1587: and p_effective_date
1588: between pceif.effective_start_date and pceif.effective_end_date
1589: and pceif.information_type like 'JP_HI%'