APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_BOOKING_STATUS_TYPES_VL

Line 28: ota_booking_status_types_vl bst

24: FROM ota_learning_path_members lpm,
25: ota_lp_member_enrollments lme,
26: ota_events evt,
27: ota_delegate_bookings tdb,
28: ota_booking_status_types_vl bst
29: WHERE lpm.activity_version_id = evt.activity_version_id
30: AND evt.event_id = tdb.event_id
31: AND bst.booking_status_type_id = tdb.booking_status_type_id
32: AND lme.learning_path_member_id = lpm.learning_path_member_id

Line 45: ota_booking_status_types_vl bst

41: SELECT DECODE(bst.type,'C','Z',bst.type) status,
42: bst.name
43: FROM ota_events evt,
44: ota_delegate_bookings tdb,
45: ota_booking_status_types_vl bst
46: WHERE evt.event_id = tdb.event_id
47: AND bst.booking_status_type_id = tdb.booking_status_type_id
48: AND evt.activity_version_id = p_activity_version_id
49: AND ((p_person_id IS NOT NULL AND tdb.delegate_person_id = p_person_id)

Line 57: l_status_name ota_booking_status_types_vl.name%TYPE := null;

53:
54: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
55:
56: l_status_type ota_booking_status_types.type%TYPE;
57: l_status_name ota_booking_status_types_vl.name%TYPE := null;
58: l_return ota_booking_status_types_vl.name%TYPE;
59:
60: BEGIN
61:

Line 58: l_return ota_booking_status_types_vl.name%TYPE;

54: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
55:
56: l_status_type ota_booking_status_types.type%TYPE;
57: l_status_name ota_booking_status_types_vl.name%TYPE := null;
58: l_return ota_booking_status_types_vl.name%TYPE;
59:
60: BEGIN
61:
62: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 133: ota_booking_status_types_vl bst

129: tdb.date_status_changed,
130: tdb.successful_attendance_flag
131: FROM ota_events evt,
132: ota_delegate_bookings tdb,
133: ota_booking_status_types_vl bst
134: WHERE evt.event_id = tdb.event_id
135: AND bst.booking_status_type_id = tdb.booking_status_type_id
136: AND evt.activity_version_id = p_activity_version_id
137: AND ((p_person_id IS NOT NULL AND tdb.delegate_person_id = p_person_id)