APPS.OTA_EVT_BUS dependencies on OTA_OFFERINGS

Line 407: FROM ota_offerings o,

403: l_dummy VARCHAR2(30);
404:
405: CURSOR dm_cr is
406: SELECT null
407: FROM ota_offerings o,
408: ota_category_usages c
409: WHERE o.offering_id = p_parent_offering_id
410: AND o.delivery_mode_id = c.category_usage_id
411: AND c.synchronous_flag = 'Y'

Line 861: from ota_offerings

857: l_start_date date;
858: l_end_date date;
859: cursor check_dates is
860: select start_date, end_date
861: from ota_offerings
862: where offering_id = p_parent_offering_id;
863: begin
864: --
865: hr_utility.set_location(' Entering:'||l_proc,10);

Line 1084: from ota_offerings

1080: l_act_vrsn_id ota_activity_versions.activity_version_id%TYPE;
1081:
1082: cursor check_dates is
1083: select start_date, end_date, activity_version_id
1084: from ota_offerings
1085: where offering_id = p_parent_offering_id;
1086:
1087: cursor check_act_dates is
1088: select start_date, end_date

Line 3588: FROM ota_offerings off,

3584: l_exists varchar2(1);
3585:
3586: CURSOR csr_offering IS
3587: SELECT null
3588: FROM ota_offerings off,
3589: ota_activity_versions act
3590: WHERE off.offering_id = p_parent_offering_id
3591: AND off.activity_version_id = act.activity_version_id
3592: AND act.activity_version_id = p_activity_version_id;