APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_DELEGATE_BOOKINGS

Line 27: ota_delegate_bookings tdb,

23: bst.name
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

Line 44: ota_delegate_bookings tdb,

40: CURSOR csr_act_enr IS
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

Line 103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE)

99: p_contact_id IN ota_learning_paths.contact_id%TYPE,
100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
101: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE)
104: IS
105:
106:
107: CURSOR csr_lp_enr IS

Line 113: ota_delegate_bookings tdb,

109: tdb.date_status_changed
110: FROM ota_learning_path_members lpm,
111: ota_lp_member_enrollments lme,
112: ota_events evt,
113: ota_delegate_bookings tdb,
114: ota_booking_status_types bst
115: WHERE lpm.activity_version_id = evt.activity_version_id
116: AND evt.event_id = tdb.event_id
117: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 129: ota_delegate_bookings tdb,

125: CURSOR csr_act_enr IS
126: SELECT DECODE(bst.type,'C','Z',bst.type) status,
127: tdb.date_status_changed
128: FROM ota_events evt,
129: ota_delegate_bookings tdb,
130: ota_booking_status_types_vl bst
131: WHERE evt.event_id = tdb.event_id
132: AND bst.booking_status_type_id = tdb.booking_status_type_id
133: AND evt.activity_version_id = p_activity_version_id

Line 142: v_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

138:
139: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
140:
141: v_enroll_status VARCHAR2(30);
142: v_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
143:
144: BEGIN
145:
146: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 182: ota_delegate_bookings b,

178: CURSOR chk_enr IS
179: SELECT NULL
180: FROM ota_events e,
181: ota_activity_versions a,
182: ota_delegate_bookings b,
183: ota_booking_status_types s,
184: ota_learning_path_members lpm
185: WHERE e.event_id = b.event_id
186: AND lpm.activity_version_id = a.activity_version_id

Line 451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;
453: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
454: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
455: