APPS.PAY_JP_WIC_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 865: from per_contact_relationships ctr,

861: to_date(decode(to_char(nvl(least(per.date_of_death, p_effective_date), p_effective_date),'YYYY/MM/DD'),
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

Line 2493: from per_contact_relationships ctr

2489: l_dummy_care_med number;
2490: --
2491: cursor csr_spouse is
2492: select 'Y'
2493: from per_contact_relationships ctr
2494: where ctr.person_id = p_person_id
2495: and ctr.contact_type = 'S'
2496: and p_effective_date
2497: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date);