APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on DUAL

Line 1419: select sysdate into l_current_date from dual;

1415: l_booking_status_row.name);
1416:
1417:
1418:
1419: select sysdate into l_current_date from dual;
1420:
1421: ota_tdb_api_ins2.Create_Enrollment( p_booking_id => l_booking_id
1422: ,p_booking_status_type_id => l_booking_status_row.booking_status_type_id
1423: ,p_delegate_person_id => l_delegate_id

Line 1654: select sysdate into l_current_date from dual;

1650: OPEN csr_chk_event(l_eventid, l_delegate_id);
1651: FETCH csr_chk_event INTO l_booking_id,l_date_booking_placed,l_object_version_number;
1652: CLOSE csr_chk_event;
1653:
1654: select sysdate into l_current_date from dual;
1655:
1656: IF l_auto_create_finance = 'Y' and
1657: l_price_basis <> 'N' and
1658: l_event_currency_code is not null THEN

Line 1975: select sysdate into l_current_date from dual;

1971: OPEN csr_chk_event(l_eventid, l_delegate_id);
1972: FETCH csr_chk_event INTO l_booking_id,l_date_booking_placed,l_object_version_number,l_business_group_id;
1973: CLOSE csr_chk_event;
1974:
1975: select sysdate into l_current_date from dual;
1976:
1977: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1978: (p_web_booking_status_type => 'CANCELLED'
1979: ,p_business_group_id => l_business_group_id);