APPS.OTA_CME_BUS dependencies on OTA_CERT_MBR_ENROLLMENTS

Line 31: , ota_cert_mbr_enrollments cme

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_cert_mbr_enrollments cme
32: where cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
33: and pbg.business_group_id = cme.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_cert_mbr_enrollments cme

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_cert_mbr_enrollments cme
102: where cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
103: and pbg.business_group_id = cme.business_group_id;
104: --
105: -- Declare local variables

Line 249: ,p_descflex_name => 'OTA_CERT_MBR_ENROLLMENTS'

245: -- b) During insert.
246: --
247: hr_dflex_utility.ins_or_upd_descflex_attribs
248: (p_appl_short_name => 'OTA'
249: ,p_descflex_name => 'OTA_CERT_MBR_ENROLLMENTS'
250: ,p_attribute_category => p_rec.attribute_category
251: ,p_attribute1_name => 'ATTRIBUTE1'
252: ,p_attribute1_value => p_rec.attribute1
253: ,p_attribute2_name => 'ATTRIBUTE2'

Line 406: (p_associated_column1 => 'OTA_CERT_MBR_ENROLLMENTS.MEMBER_STATUS_CODE') THEN

402:
403: WHEN app_exception.application_exception THEN
404:
405: IF hr_multi_message.exception_add
406: (p_associated_column1 => 'OTA_CERT_MBR_ENROLLMENTS.MEMBER_STATUS_CODE') THEN
407:
408: hr_utility.set_location(' Leaving:'||l_proc, 42);
409: RAISE;
410: END IF;