APPS.PAY_JP_WIC_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 720: from per_contact_relationships ctr,

716: decode(ctr.contact_type, 'S', decode(p_sex, 'F', g_prompt_kanji.husband, g_prompt_kanji.wife),
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

Line 1428: from per_contact_relationships ctr

1424: l_dummy_number number;
1425: --
1426: cursor csr_spouse is
1427: select 'Y'
1428: from per_contact_relationships ctr
1429: where ctr.person_id = p_person_id
1430: and ctr.contact_type = 'S'
1431: and p_effective_date
1432: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date);