[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT addr.style
, addr.address_line1
, addr.address_line2
, addr.address_line3
, addr.address_type
, addr.country
, addr.postal_code
, addr.region_1
, addr.region_2
, addr.region_3
, addr.town_or_city
, addr.add_information13
, addr.add_information14
, addr.add_information15
, addr.add_information16
, addr.add_information17
, addr.add_information18
, addr.add_information19
, addr.add_information20
, NULL
FROM per_addresses addr
WHERE addr.person_id = cp_person_id
AND TRUNC(sysdate)
BETWEEN date_from
AND NVL(addr.date_to
,TRUNC(SYSDATE))
AND addr.primary_flag = 'Y'
AND addr.address_type = 'H';
SELECT fdc.application_column_name
FROM fnd_descr_flex_column_usages fdc
WHERE fdc.descriptive_flexfield_name = 'Address Structure'
AND fdc.enabled_flag = 'Y'
AND fdc.display_flag = 'Y'
AND fdc.application_column_name NOT LIKE 'TELEPHONE_NUMBER%'
AND fdc.descriptive_flex_context_code = cp_addr_style
ORDER BY fdc.column_seq_num;
SELECT psn.full_name contact_person_name
, pho.phone_number contact_phone_number
, pho.phone_type phone_type
FROM per_contact_relationships con
, per_all_people_f psn
, per_phones pho
WHERE psn.person_id = con.contact_person_id
AND psn.person_id = pho.parent_id (+)
AND pho.parent_table= 'PER_ALL_PEOPLE_F'
AND con.person_id = cp_person_id
AND con.contact_type = 'EMRG'
AND TRUNC(sysdate)
BETWEEN psn.effective_start_date
AND psn.effective_end_date
AND TRUNC(SYSDATE)
BETWEEN con.date_start
AND NVL(con.date_end
,hr_general.end_of_time)
AND TRUNC(SYSDATE)
BETWEEN NVL(pho.date_from
,hr_general.start_of_time)
AND NVL(pho.date_to
,hr_general.end_of_time);