APPS.PAY_JP_REPORT_PKG dependencies on PER_ALL_PEOPLE_F

Line 236: per_all_people_f pcon,

232: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE_KANA'),fnd_message.get_string('PAY','PAY_JP_HUSBAND_KANA')),flv2.meaning) CONTACT_TYPE_KANA
233: from
234: hr_lookups flv2,
235: hr_lookups flv1,
236: per_all_people_f pcon,
237: per_contact_relationships pcr,
238: per_all_people_f pp
239: where pp.person_id=p_person_id
240: and p_effective_date

Line 238: per_all_people_f pp

234: hr_lookups flv2,
235: hr_lookups flv1,
236: per_all_people_f pcon,
237: per_contact_relationships pcr,
238: per_all_people_f pp
239: where pp.person_id=p_person_id
240: and p_effective_date
241: between pp.effective_start_date and pp.effective_end_date
242: and pcr.person_id=pp.person_id

Line 251: from per_all_people_f pcon2

247: and ( (p_effective_date
248: between pcon.effective_start_date and pcon.effective_end_date)
249: or (not exists(
250: select NULL
251: from per_all_people_f pcon2
252: where pcon2.person_id=pcon.person_id
253: and p_effective_date
254: between pcon2.effective_start_date and pcon2.effective_end_date)
255: and pcon.effective_start_date=pcon.start_date))

Line 1419: per_all_people_f papf

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'
1423: AND p_effective_date

Line 1648: p_person_id per_all_people_f.person_id%TYPE,

1644: --
1645: end chk_use_contact_extra_info;
1646: --
1647: FUNCTION get_si_dependent_report_type(
1648: p_person_id per_all_people_f.person_id%TYPE,
1649: p_qualified_date DATE) RETURN NUMBER IS
1650: --
1651: CURSOR cel_added IS
1652: SELECT 1 FROM per_jp_si_dependent_transfer_v

Line 1734: p_person_id per_all_people_f.person_id%TYPE,

1730: --
1731: END get_si_dependent_report_type;
1732: --
1733: FUNCTION get_si_dep_ee_effective_date(
1734: p_person_id per_all_people_f.person_id%TYPE,
1735: p_date_from DATE,
1736: p_date_to DATE,
1737: p_report_type hr_lookups.lookup_code%TYPE) RETURN DATE IS
1738: --