APPS.PAY_JP_REPORT_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 1409: per_contact_extra_info_f pceif,

1405: DECODE(pceif.cei_information6,
1406: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),
1407: '30', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER'), NULL) || ')',1,2000)) details
1408: FROM per_contact_relationships pcr,
1409: per_contact_extra_info_f pceif,
1410: per_all_people_f papf
1411: WHERE pcr.person_id = p_person_id
1412: AND pcr.cont_information_category = 'JP'
1413: AND pcr.cont_information1 = 'Y'

Line 1477: per_contact_extra_info_f pceif

1473: WHERE EXISTS(
1474: SELECT /*+ ORDERED */
1475: NULL
1476: FROM per_contact_relationships pcr,
1477: per_contact_extra_info_f pceif
1478: WHERE pcr.person_id = p_person_id
1479: AND pcr.cont_information_category = 'JP'
1480: AND pcr.cont_information1 = 'Y'
1481: AND p_effective_date

Line 1576: from per_contact_extra_info_f pceif

1572: and p_effective_date
1573: between nvl(pcr.date_start, p_effective_date) and nvl(pcr.date_end, p_effective_date)
1574: and exists(
1575: select null
1576: from per_contact_extra_info_f pceif
1577: where pceif.contact_relationship_id = pcr.contact_relationship_id
1578: and p_effective_date
1579: between pceif.effective_start_date and pceif.effective_end_date
1580: and pceif.information_type like 'JP_HI%'