DBA Data[Home] [Help]

APPS.OTA_CANCEL_API dependencies on FND_USER

Line 83: l_user_name fnd_user.user_name%type;

79: l_enr_ovn ota_delegate_bookings.object_version_number%type;
80: l_booking_status_type ota_booking_status_types.type%type;
81: l_tfl_ovn ota_finance_lines.object_version_number%type;
82: l_new_fl ota_finance_lines.finance_line_id%type;
83: l_user_name fnd_user.user_name%type;
84:
85: l_cancel_hours number := FND_PROFILE.VALUE('OTA_AUTO_WAITLIST_DAYS');
86:
87: l_different_hours number(11,3);

Line 122: FND_USER

118: CURSOR C_USER IS
119: SELECT
120: USER_NAME
121: FROM
122: FND_USER
123: WHERE
124: Employee_id = l_owner_id
125: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
126: