APPS.OTA_OM_UPD_API dependencies on OTA_BOOKING_STATUS_TYPES

Line 1048: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;

1044: l_version number := NULL;
1045: l_type_id number;
1046: l_finance_line_id number := NULL;
1047: l_meaning varchar2(100);
1048: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1049: l_booking_priority ota_delegate_bookings.booking_priority%TYPE := NULL;
1050: l_delegate_contact_phone varchar2(80);
1051: l_delegate_contact_fax varchar2(80);
1052: l_delegate_contact_email HZ_PARTIES.email_address%TYPE; ---changed

Line 1084: From ota_booking_status_types

1080:
1081: Cursor get_booking_status_type_id IS
1082: Select booking_status_type_id,
1083: name
1084: From ota_booking_status_types
1085: Where active_flag = 'Y'
1086: And default_flag = 'Y'
1087: And type = 'W'
1088: and business_group_id = L_BUSINESS_GROUP_ID;