APPS.PAY_JP_WIC_PKG dependencies on PER_ALL_PEOPLE_F

Line 721: per_all_people_f per

717: hr_general.decode_lookup('CONTACT', ctr.contact_type)) D_CONTACT_TYPE_KANJI,
718: decode(ctr.contact_type, 'S', decode(p_sex, 'F', g_prompt_kana.husband, g_prompt_kana.wife),
719: hr_jp_standard_pkg.to_hankaku(hr_general.decode_lookup('JP_CONTACT_KANA', ctr.contact_type))) D_CONTACT_TYPE_KANA
720: from per_contact_relationships ctr,
721: per_all_people_f per
722: where ctr.person_id = p_person_id
723: and ctr.dependent_flag = 'Y'
724: and p_effective_date
725: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date)

Line 733: from per_all_people_f per2

729: or (
730: per.effective_start_date = per.start_date
731: and not exists(
732: select null
733: from per_all_people_f per2
734: where per2.person_id = per.person_id
735: and p_effective_date
736: between per2.effective_start_date and per2.effective_end_date)
737: )

Line 2418: from per_all_people_f per,

2414: wic.leaving_reason,
2415: per.per_information18 LAST_NAME_KANJI,
2416: per.last_name LAST_NAME_KANA,
2417: wic.employment_category
2418: from per_all_people_f per,
2419: hr_organization_information hoi,
2420: pay_all_payrolls_f pay,
2421: /* Use V2 instead of V for debugging. */
2422: pay_jp_wic_assacts_v2 wic