[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pt.party_name party_name
from hz_relationships pr,
hz_organization_profiles op,
hz_parties pt
where pr.party_id = pc_partner_id
and pr.subject_table_name = 'HZ_PARTIES'
and pr.object_table_name = 'HZ_PARTIES'
and pr.status in ('A', 'I')
and pr.object_id = op.party_id
and op.internal_flag = 'Y'
and op.effective_end_date is null
and pr.subject_id = pt.party_id
and pt.status in ('A', 'I');
select category, source_id
from jtf_rs_resource_extns extn, fnd_user usr
where extn.user_id = usr.user_id
and usr.user_id = pc_user_id;
select d.party_name
from hz_relationships b,
hz_relationships c,
hz_organization_profiles po,
hz_parties d
where b.party_id = pc_pt_contact_id
and b.subject_table_name = 'HZ_PARTIES'
and b.object_table_name = 'HZ_PARTIES'
and b.directional_flag = 'F'
and b.relationship_code = 'EMPLOYEE_OF'
and b.relationship_type = 'EMPLOYMENT'
and (b.end_date is null or b.end_date > sysdate)
and b.status = 'A'
and b.object_id = c.subject_id
and c.subject_table_name = 'HZ_PARTIES'
and c.object_table_name = 'HZ_PARTIES'
and (c.end_date is null or c.end_date > sysdate)
and c.status = 'A'
and c.object_id = po.party_id
and d.party_id = b.subject_id
and po.internal_flag = 'Y'
and po.effective_end_date is null;
FOR lc_cur IN (select name from pv_attributes_vl where attribute_id = p_attribute_id)
LOOP
l_attribute_name := lc_cur.name;
SELECT PV_LEAD_WORKFLOWS_S.nextval
INTO l_itemKey
FROM dual;