APPS.OTA_PLE_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 172: select 1 from ota_activity_versions

168: )
169: is
170: ---------------------
171: cursor csr_tav is
172: select 1 from ota_activity_versions
173: where activity_version_id = p_tav_id;
174: --
175: l_parent_exists boolean;
176: -------------

Line 327: l_activity_id ota_activity_versions.activity_version_id%type;

323: cursor csr_vsp is
324: select activity_version_id from ota_vendor_supplies
325: where vendor_supply_id = p_vsp_id;
326: --
327: l_activity_id ota_activity_versions.activity_version_id%type;
328: --
329: procedure chkp is
330: -------------
331: begin

Line 417: from ota_activity_versions

413: --*** Activity version id may be null in ota_price_list_entries
414: ---------------------
415: cursor csr_tav_date is
416: select start_date
417: from ota_activity_versions
418: where activity_version_id = p_tav_id;
419: --
420: l_tav_startdate date;
421: --

Line 525: from ota_activity_versions

521: --*** Activity version id may be null in ota_price_list_entries
522: ---------------------
523: cursor csr_tav_date is
524: select end_date
525: from ota_activity_versions
526: where activity_version_id = p_tav_id;
527: --
528: l_tav_enddate date;
529: --

Line 708: l_tav_id ota_activity_versions.activity_version_id%type;

704: p_rec in OTA_PLE_SHD.g_rec_type
705: )
706: is
707: ---------------------
708: l_tav_id ota_activity_versions.activity_version_id%type;
709: --
710: begin
711: --
712: check_table_constraints (p_rec);

Line 902: from ota_activity_versions

898: or p_proc_use <>2);
899: --
900: cursor get_activity is
901: select start_date,end_date
902: from ota_activity_versions
903: where activity_version_id = l_activity_version_id;
904: --
905: l_copy boolean;
906: l_dates_difference number;