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 117: -- per_contact_relationships ctr,

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

Line 193: per_contact_relationships ctr,

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