APPS.OTA_ENROLL_REVIEW_SS dependencies on DUAL

Line 1279: select sysdate into l_current_date from dual;

1275: l_booking_status_row.name);
1276:
1277:
1278:
1279: select sysdate into l_current_date from dual;
1280:
1281: ota_tdb_api_ins2.Create_Enrollment( p_booking_id => l_booking_id
1282: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
1283: ,p_delegate_person_id => l_delegate_id

Line 1515: select sysdate into l_current_date from dual;

1511: OPEN csr_chk_event(l_eventid, l_delegate_id);
1512: FETCH csr_chk_event INTO l_booking_id,l_date_booking_placed,l_object_version_number;
1513: CLOSE csr_chk_event;
1514:
1515: select sysdate into l_current_date from dual;
1516:
1517: IF l_auto_create_finance = 'Y' and
1518: l_price_basis <> 'N' and
1519: l_event_currency_code is not null THEN

Line 1846: select sysdate into l_current_date from dual;

1842: OPEN csr_chk_event(l_eventid, l_delegate_id);
1843: FETCH csr_chk_event INTO l_booking_id,l_date_booking_placed,l_object_version_number,l_business_group_id;
1844: CLOSE csr_chk_event;
1845:
1846: select sysdate into l_current_date from dual;
1847:
1848: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1849: (p_web_booking_status_type => 'CANCELLED'
1850: ,p_business_group_id => l_business_group_id);