APPS.OTA_TRAINING_SS dependencies on DUAL

Line 1727: select sysdate into l_current_date from dual;

1723: l_booking_status_row.name);
1724:
1725:
1726:
1727: select sysdate into l_current_date from dual;
1728:
1729: ota_tdb_api_ins2.Create_Enrollment( p_booking_id => l_booking_id
1730: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
1731: ,p_delegate_person_id => l_delegate_id

Line 1964: select sysdate into l_current_date from dual;

1960: OPEN csr_chk_event(l_eventid, l_delegate_id);
1961: FETCH csr_chk_event INTO l_booking_id,l_date_booking_placed,l_object_version_number;
1962: CLOSE csr_chk_event;
1963:
1964: select sysdate into l_current_date from dual;
1965:
1966: IF l_auto_create_finance = 'Y' and
1967: l_price_basis <> 'N' and
1968: l_event_currency_code is not null THEN

Line 2325: select sysdate into l_current_date from dual;

2321: return;
2322: end if;
2323: CLOSE csr_chk_event;
2324:
2325: select sysdate into l_current_date from dual;
2326:
2327: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
2328: (p_web_booking_status_type => 'CANCELLED'
2329: ,p_business_group_id => l_business_group_id);