APPS.OTA_LME_BUS dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 31: , ota_lp_member_enrollments lme

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_lp_member_enrollments lme
32: where lme.lp_member_enrollment_id = p_lp_member_enrollment_id
33: and pbg.business_group_id = lme.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_lp_member_enrollments lme

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_lp_member_enrollments lme
102: where lme.lp_member_enrollment_id = p_lp_member_enrollment_id
103: and pbg.business_group_id = lme.business_group_id;
104: --
105: -- Declare local variables

Line 274: ,p_descflex_name => 'OTA_LP_MEMBER_ENROLLMENTS'

270: -- b) During insert.
271: --
272: hr_dflex_utility.ins_or_upd_descflex_attribs
273: (p_appl_short_name => 'OTA'
274: ,p_descflex_name => 'OTA_LP_MEMBER_ENROLLMENTS'
275: ,p_attribute_category => p_rec.attribute_category
276: ,p_attribute1_name => 'ATTRIBUTE1'
277: ,p_attribute1_value => p_rec.attribute1
278: ,p_attribute2_name => 'ATTRIBUTE2'

Line 452: (p_associated_column1 => 'OTA_LP_MEMBER_ENROLLMENTS.MEMBER_STATUS_CODE') THEN

448:
449: WHEN app_exception.application_exception THEN
450:
451: IF hr_multi_message.exception_add
452: (p_associated_column1 => 'OTA_LP_MEMBER_ENROLLMENTS.MEMBER_STATUS_CODE') THEN
453:
454: hr_utility.set_location(' Leaving:'||l_proc, 42);
455: RAISE;
456: END IF;