APPS.OTA_EVT_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 906: from ota_activity_versions_v

902: l_start_date date;
903: l_end_date date;
904: cursor check_dates is
905: select start_date, end_date
906: from ota_activity_versions_v
907: where activity_version_id = p_activity_version_id;
908: begin
909: --
910: hr_utility.set_location(' Entering:'||l_proc,10);

Line 1078: l_act_start_date ota_activity_versions.start_date%TYPE;

1074: l_end_date date;
1075: l_evt_start_date date;
1076: l_evt_end_date date;
1077: --
1078: l_act_start_date ota_activity_versions.start_date%TYPE;
1079: l_act_end_date ota_activity_versions.end_date%TYPE;
1080: l_act_vrsn_id ota_activity_versions.activity_version_id%TYPE;
1081:
1082: cursor check_dates is

Line 1079: l_act_end_date ota_activity_versions.end_date%TYPE;

1075: l_evt_start_date date;
1076: l_evt_end_date date;
1077: --
1078: l_act_start_date ota_activity_versions.start_date%TYPE;
1079: l_act_end_date ota_activity_versions.end_date%TYPE;
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

Line 1080: l_act_vrsn_id ota_activity_versions.activity_version_id%TYPE;

1076: l_evt_end_date date;
1077: --
1078: l_act_start_date ota_activity_versions.start_date%TYPE;
1079: l_act_end_date ota_activity_versions.end_date%TYPE;
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

Line 1089: from ota_activity_versions

1085: where offering_id = p_parent_offering_id;
1086:
1087: cursor check_act_dates is
1088: select start_date, end_date
1089: from ota_activity_versions
1090: where activity_version_id = l_act_vrsn_id;
1091:
1092: begin
1093: --

Line 1233: from ota_activity_versions

1229: l_evt_end_date date;
1230: --
1231: cursor check_dates is
1232: select start_date, end_date
1233: from ota_activity_versions
1234: where activity_version_id = p_activity_version_id;
1235: begin
1236: --
1237: hr_utility.set_location(' Entering:'||l_proc,10);

Line 3569: ota_activity_versions act

3565:
3566: CURSOR csr_offering IS
3567: SELECT null
3568: FROM ota_offerings off,
3569: ota_activity_versions act
3570: WHERE off.offering_id = p_parent_offering_id
3571: AND off.activity_version_id = act.activity_version_id
3572: AND act.activity_version_id = p_activity_version_id;
3573: