APPS.PAY_JP_WIC_PKG dependencies on PER_ALL_PEOPLE_F

Line 866: per_all_people_f per

862: to_char(per.date_of_death,'YYYY/MM/DD'), to_char(per.date_of_death,'YYYY/MM/DD'),
863: to_char(add_months(trunc(p_effective_date, 'YYYY'), 12) - 1,'YYYY/MM/DD')),'YYYY/MM/DD') + 1,
864: per.date_of_birth) / 12) age
865: from per_contact_relationships ctr,
866: per_all_people_f per
867: where ctr.person_id = p_person_id
868: and ctr.dependent_flag = 'Y'
869: and p_effective_date
870: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date)

Line 878: from per_all_people_f per2

874: or (
875: per.effective_start_date = per.start_date
876: and not exists(
877: select null
878: from per_all_people_f per2
879: where per2.person_id = per.person_id
880: and p_effective_date
881: between per2.effective_start_date and per2.effective_end_date)
882: )

Line 3909: from per_all_people_f per,

3905: wic.leaving_reason,
3906: per.per_information18 LAST_NAME_KANJI,
3907: per.last_name LAST_NAME_KANA,
3908: wic.employment_category
3909: from per_all_people_f per,
3910: hr_organization_information hoi,
3911: pay_all_payrolls_f pay,
3912: /* Use V2 instead of V for debugging. */
3913: pay_jp_wic_assacts_v2 wic