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 1663: select sysdate into l_current_date from dual;

1659: hr_utility.set_message(810, 'OTA_467215_ENR_STATUS_CHANGED');
1660: hr_utility.raise_error;
1661: END IF;
1662:
1663: select sysdate into l_current_date from dual;
1664:
1665: IF l_auto_create_finance = 'Y' and
1666: l_price_basis <> 'N' and
1667: l_event_currency_code is not null THEN

Line 1984: select sysdate into l_current_date from dual;

1980: OPEN csr_chk_event(l_eventid, l_delegate_id);
1981: FETCH csr_chk_event INTO l_booking_id,l_date_booking_placed,l_object_version_number,l_business_group_id;
1982: CLOSE csr_chk_event;
1983:
1984: select sysdate into l_current_date from dual;
1985:
1986: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1987: (p_web_booking_status_type => 'CANCELLED'
1988: ,p_business_group_id => l_business_group_id);