[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(contact_extra_info_id)
from per_contact_extra_info_f cei
where cei.contact_relationship_id = P_CONTACT_RELATIONSHIP_ID
and cei.information_type = P_INFORMATION_TYPE
and to_char(P_EFFECTIVE_START_DATE,'yyyy') = to_char(cei.effective_start_date,'yyyy');
select ctr.cont_information2 itax_law,
nvl(ctr.cont_information11, '0') kr_cont_type,
decode(ctr.contact_type, 'P', '1', 'S', '3', 'A', '4', 'C', '4', 'R', '4', 'O', '4', 'T', '4', '6') cont_type
from per_contact_relationships ctr
where ctr.cont_information_category = 'KR'
and ctr.cont_information1 = 'Y'
and ((ctr.cont_information9 ='D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(trunc(add_months(date_end,12),'YYYY')-1,p_effective_date))
or (nvl(ctr.cont_information9,'XXX') <>'D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(date_end, p_effective_date))
)
and ctr.contact_relationship_id = p_contact_relationship_id;
select ctr.cont_information2 itax_law,
nvl(ctr.cont_information11, '0') kr_cont_type,
decode(ctr.contact_type, 'S','3','P','1','B','5','SISTER','5',
'A','4','C','4','R','4','O','4','T','4','6') cont_type --Bug 12714266
from per_contact_relationships ctr
where ctr.cont_information_category = 'KR'
and ctr.cont_information1 = 'Y'
and ((ctr.cont_information9 ='D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(trunc(add_months(date_end,12),'YYYY')-1,p_effective_date))
or (nvl(ctr.cont_information9,'XXX') <>'D' and p_effective_date between nvl(date_start, p_effective_date) and nvl(date_end, p_effective_date))
)
and ctr.contact_relationship_id = p_contact_relationship_id;