APPS.PER_JP_CTR_UTILITY_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 57: -- PER_CONTACT_RELATIONSHIPS

53: -- |--------------------------< get_itax_dpnt_info >--------------------------|
54: -- ----------------------------------------------------------------------------
55: --
56: -- Procedure to derive dependent information from
57: -- PER_CONTACT_RELATIONSHIPS
58: -- PER_CONTACT_EXTRA_INFO_F
59: --
60: -- ----------------------------------------------------------------------------
61: procedure get_itax_dpnt_info(

Line 118: -- per_contact_relationships ctr,

114: -- per.date_of_death,
115: -- nvl(least(per.date_of_death, l_effective_date), l_effective_date) EFFECTIVE_DATE,
116: -- to_number(ctr.cont_information2) SEQUENCE
117: -- from per_all_assignments_f asg,
118: -- per_contact_relationships ctr,
119: -- per_all_people_f per
120: -- where asg.assignment_id = p_assignment_id
121: -- and l_effective_date
122: -- between asg.effective_start_date and asg.effective_end_date

Line 196: per_contact_relationships ctr,

192: per.per_information19 FIRST_NAME_KANJI,
193: per.last_name LAST_NAME_KANA,
194: per.first_name FIRST_NAME_KANA
195: from per_all_assignments_f asg,
196: per_contact_relationships ctr,
197: per_contact_extra_info_f cei,
198: per_all_people_f per,
199: hr_lookups hrl1,
200: hr_lookups hrl2