[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hao.business_group_id,
evt.organization_id,
evt.currency_code,
evt.course_start_date,
evt.course_end_date,
evt.Title,
evt.owner_id,
evt.activity_version_id,
evt.offering_id
FROM OTA_EVENTS_VL evt,
HR_ALL_ORGANIZATION_UNITS hao
WHERE evt.event_id = pp_event_id
AND evt.organization_id = hao.organization_id (+); -- Bug 2213009
Select event_status, maximum_internal_attendees
from OTA_EVENTS
WHERE EVENT_ID = TO_NUMBER(p_event_id);
SELECT count(*)
FROM OTA_DELEGATE_BOOKINGS dbt,
OTA_BOOKING_STATUS_TYPES bst
WHERE dbt.event_id = TO_NUMBER(p_event_id)
AND dbt.internal_booking_flag = 'Y'
AND dbt.booking_status_type_id = bst.booking_status_type_id
AND bst.type in ('P','A','E');
SELECT nvl(price_basis,NULL)
FROM ota_events
where event_id = p_event_id;
SELECT
USER_NAME
FROM
FND_USER
WHERE
Employee_id = p_owner_id ;
SELECT version_name
FROM OTA_ACTIVITY_VERSIONS_TL
WHERE activity_version_id = p_activity_version_id
AND language=userenv('LANG');
UPDATE ota_finance_lines SET transfer_status = 'AT'
WHERE finance_line_id = l_finance_line_id;
SELECT FLN.finance_line_id finance_line_id,
FLN.finance_header_id finance_header_id,
FLN.transfer_status transfer_status,
FLN.booking_id booking_id,
FLN.object_version_number object_version_number,
FLN.sequence_number sequence_number,
FLN.Cancelled_flag cancelled_flag
FROM OTA_FINANCE_LINES FLN
WHERE FLN.booking_id = p_booking_id;
SELECT count(*)
FROM OTA_FINANCE_LINES FLN
WHERE FLN.finance_header_id = p_finance_header_id;
SELECT FLH.finance_header_id finance_header_id,
FLH.cancelled_flag cancelled_flag,
FLH.transfer_status transfer_status,
FLH.object_version_number object_version_number
FROM OTA_FINANCE_HEADERS FLH,
OTA_FINANCE_LINES FLN
WHERE FLH.finance_header_id = FLN.finance_header_id
AND FLN.booking_id = p_booking_id;
SELECT assg.assignment_id,
assg.business_group_id,
assg.organization_id,
pcak.cost_allocation_keyflex_id,
pcak.concatenated_segments,
pcaf.proportion
FROM per_all_people_f per,
per_all_assignments_f assg,
pay_cost_allocations_f pcaf,
pay_cost_allocation_keyflex pcak
WHERE per.person_id = p_person_id
AND per.person_id = assg.person_id
AND assg.assignment_id = pcaf.assignment_id
AND assg.Primary_flag = 'Y'
AND pcaf.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id
AND pcak.enabled_flag = 'Y'
AND sysdate between nvl(pcaf.effective_start_date,sysdate)
and nvl(pcaf.effective_end_date,sysdate+1)
AND sysdate between nvl(assg.effective_start_date,sysdate)
and nvl(assg.effective_end_date,sysdate+1)
AND sysdate between nvl(per.effective_start_date,sysdate)
and nvl(per.effective_end_date,sysdate+1);
SELECT assg.assignment_id,
assg.business_group_id,
assg.organization_id
FROM per_all_people_f per,
per_all_assignments_f assg
WHERE per.person_id = p_delegate_id
AND per.person_id = assg.person_id
AND sysdate between nvl(assg.effective_start_date,sysdate)
and nvl(assg.effective_end_date,sysdate+1)
AND assg.primary_flag = 'Y'
AND sysdate between nvl(per.effective_start_date,sysdate)
and nvl(per.effective_end_date,sysdate+1);
SELECT
EMPLOYEE_ID
FROM
FND_USER
WHERE
user_id = l_current_user_id ;
select hr_workflow_item_key_s.nextval
into l_item_key
from sys.dual;
SELECT ov.booking_id
FROM ota_booking_status_types os,
ota_delegate_bookings ov
WHERE ov.event_id = p_event_id
AND ov.delegate_person_id = p_person_id
AND os.booking_status_type_id = ov.booking_status_type_id
AND os.type = 'C';
SELECT ov.booking_id
FROM ota_booking_status_types os,
ota_delegate_bookings ov
WHERE ov.event_id = p_event_id
AND ov.delegate_person_id = p_person_id
AND os.booking_status_type_id = ov.booking_status_type_id
AND os.type <> 'C';
SELECT secure_event_flag,organization_id
from ota_events
where event_id = p_event_id;
SELECT organization_id
from per_all_assignments_f
where person_id = p_delegate_id and
trunc(sysdate) between effective_start_date and
effective_end_date;
SELECT ea.organization_id, ea.job_id, ea.position_id
FROM ota_event_associations ea
WHERE ea.event_id = p_event_id;
SELECT course_start_date
-- FROM otv_scheduled_events
FROM ota_events
WHERE event_id = p_event_id and
--Bug#2201434 SELFPACED event_type included.
-- event_type='SCHEDULED' and
event_type in ('SCHEDULED','SELFPACED') and
event_status in('P','N','F')and
TRUNC(SYSDATE) BETWEEN NVL( ENROLMENT_START_DATE, TRUNC(
SYSDATE)) AND
NVL( ENROLMENT_END_DATE, TRUNC( SYSDATE)) AND
TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
SELECT a.assignment_id
FROM per_all_assignments_f a
WHERE a.person_id = p_delegate_id
AND NVL(p_course_start_date,trunc(sysdate)) BETWEEN
a.effective_start_date AND a.effective_end_date
AND NVL(p_organization_id, -1) = DECODE(p_organization_id, null, -1,
NVL(a.organization_id,-1))
AND NVL(p_job_id, -1) = DECODE(p_job_id, null, -1,
NVL(a.job_id, -1))
AND NVL(p_position_id,-1) = DECODE(p_position_id, null, -1,
NVL(a.position_id, -1))
AND a.assignment_type = 'E';
select '1'
from per_person_types ppt ,
per_all_people_f per, ota_events evt,
per_person_type_usages_f ptu
where per.business_group_id = ppt.business_group_id
and ppt.system_person_type in ('EMP','CWK','OTHER')
and per.person_id=nvl(p_delegate_id,per.person_id)
and ptu.person_id=per.person_id
and ptu.person_type_id=ppt.person_type_id
and (( (evt.course_start_date between per.effective_start_date and per.effective_end_date
and evt.course_start_date between ptu.effective_start_date and ptu.effective_end_date)
or (evt.event_status = 'P'
and evt.enrolment_start_date between
per.effective_start_date and per.effective_end_date and evt.enrolment_start_date between
ptu.effective_start_date and ptu.effective_end_date) ) or evt.event_type = 'SELFPACED')
and evt.event_id = p_event_id ;
SELECT null
FROM wf_item_activity_statuses_v wf
WHERE activity_name = p_activity
AND activity_status_code = 'NOTIFIED'
AND item_type = p_item_type
AND item_key = p_item_key;
SELECT usr.user_name,
evt.offering_id
FROM OTA_EVENTS evt,
FND_USER USR
WHERE evt.event_id = p_event_id and
usr.employee_id = evt.owner_id;
SELECT bst.Type
FROM OTA_DELEGATE_BOOKINGS tdb,
OTA_BOOKING_STATUS_TYPES bst
WHERE tdb.booking_id = p_booking_id
AND bst.booking_status_type_id = tdb.booking_status_type_id;
SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
from ota_events EVT, ota_event_associations EVA
where EVT.event_id = p_event_id and
EVT.event_id = EVA.event_id and
EVA.customer_id is not null;
SELECT object_version_number
FROM ota_delegate_bookings
WHERE booking_id = p_booking_id;