APPS.PER_REI_BUS dependencies on PER_CONTACT_EXTRA_INFO_F

Line 92: -- per_contact_extra_info_f and PER_BUSINESS_GROUPS

88: --
89: -- Declare cursor
90: --
91: -- EDIT_HERE In the following cursor statement add join(s) between
92: -- per_contact_extra_info_f and PER_BUSINESS_GROUPS
93: -- so that the legislation_code for
94: -- the current business group context can be derived.
95: -- Remove this comment when the edit has been completed.
96: cursor csr_leg_code is

Line 100: , per_contact_extra_info_f cei

96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups_perf pbg
99: , per_contact_relationships ctr
100: , per_contact_extra_info_f cei
101: where cei.contact_extra_info_id = p_contact_extra_info_id
102: and ctr.contact_relationship_id = cei.contact_relationship_id
103: and pbg.business_group_id = ctr.business_group_id;
104: --

Line 192: p_contact_relationship_id IN per_contact_extra_info_f.contact_relationship_id%TYPE) IS

188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: PROCEDURE chk_contact_relationship_id(
192: p_contact_relationship_id IN per_contact_extra_info_f.contact_relationship_id%TYPE) IS
193: --
194: l_proc VARCHAR2(72) := g_package || 'chk_contact_relationship_id';
195: l_dummy VARCHAR2(1);
196: --

Line 344: from per_contact_extra_info_f

340: -- Note p_contact_extra_info_id for INSERTING is null.
341: --
342: select min(effective_start_date)
343: into l_min_esd
344: from per_contact_extra_info_f
345: where contact_relationship_id = p_contact_relationship_id
346: and information_type = p_information_type
347: and contact_extra_info_id <> nvl(p_contact_extra_info_id, -1)
348: and effective_end_date >= p_validation_start_date

Line 1030: -- but also any selfservice modules which reference PER_CONTACT_EXTRA_INFO_F df.

1026: -- Note that we do not have to create this profile option
1027: -- in FND_PROFILE_OPTIONS, this profile option is created dynamically
1028: -- in memory by the following code.
1029: -- Remember to populate PER_CONTACT_RELATIONSHIP_ID to not only forms PERWSREI.fmb
1030: -- but also any selfservice modules which reference PER_CONTACT_EXTRA_INFO_F df.
1031: --
1032: fnd_profile.put('PER_CONTACT_RELATIONSHIP_ID', to_char(p_rec.contact_relationship_id));
1033: --
1034: per_rei_bus.chk_ddf(p_rec);

Line 1095: -- but also any selfservice modules which reference PER_CONTACT_EXTRA_INFO_F df.

1091: -- Note that we do not have to create this profile option
1092: -- in FND_PROFILE_OPTIONS, this profile option is created dynamically
1093: -- in memory by the following code.
1094: -- Remember to populate PER_CONTACT_RELATIONSHIP_ID to not only forms PERWSREI.fmb
1095: -- but also any selfservice modules which reference PER_CONTACT_EXTRA_INFO_F df.
1096: --
1097: fnd_profile.put('PER_CONTACT_RELATIONSHIP_ID', to_char(p_rec.contact_relationship_id));
1098: --
1099: per_rei_bus.chk_ddf(p_rec);