[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hp.party_id
from pa_project_parties ppp,
pa_control_items pci,
hz_parties hp
where pci.ci_id = p_ci_id
and ppp.project_role_id = 1
and ppp.project_id = pci.project_id
and trunc(sysdate) between ppp.start_date_active and nvl(ppp.end_date_active, sysdate)
AND ((ppp.resource_type_id = 101 and hp.orig_system_reference = 'PER:' || ppp.resource_source_id
) or (ppp.resource_type_id = 112 and hp.party_id = ppp.resource_source_id
));
select party_id from
(
select hp.party_id
from fnd_user fu,
hz_parties hp
where fu.user_id = fnd_global.user_id
and fu.employee_id is null
and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
union
select hp.party_id
from fnd_user fu,
hz_parties hp
where fu.user_id = fnd_global.user_id
and fu.employee_id is not null
and 'PER:' || fu.employee_id = hp.orig_system_reference);
SELECT
pci.project_id,
pci.object_id,
pci.object_type,
pci.date_required,
pct.short_name ci_type_name,
pci.ci_number,
summary,
decode(highlighted_flag, 'N', 'No', 'Yes') highlighted,
priority_code,
hp.party_name,
pcc.class_code classification,
pci.record_version_number record_version_number,
pl.meaning ci_type_class
FROM pa_control_items pci, pa_ci_types_tl pct,
pa_ci_types_b pcb, pa_lookups pl, hz_parties hp,
pa_class_codes pcc
WHERE ci_id = p_ci_id
and pci.ci_type_id = pct.ci_type_id
and pl.lookup_code = pcb.ci_type_class_code
AND pcb.ci_type_id = pct.ci_type_id
and pl.lookup_type = 'PA_CI_TYPE_CLASSES'
and pci.owner_id = hp.party_id
AND pct.language = userenv('lang') /*Bug#12553990*/
AND pcc.class_code_id = pci.classification_code_id;
SELECT
customer_name,
person_name,
carrying_out_organization_name
FROM pa_project_lists_v
WHERE project_id = l_project_id;
SELECT user_name
FROM fnd_user
WHERE user_id = FND_GLOBAL.user_id;
select user_name, party_name, email_address
from (
select fu.user_name, hp.party_name, hp.email_address
from fnd_user fu,
hz_parties hp
where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
and hp.party_id = l_proj_mgr_id
and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
union
select fu.user_name, hp.party_name, hp.email_address
from fnd_user fu,
hz_parties hp,
per_all_people_f papf
where
fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
AND 'PER:' = Substr(hp.orig_system_reference,1,4) -- 'PER:' || fu.employee_id = hp.orig_system_reference
and hp.party_id = l_proj_mgr_id
and trunc(sysdate)
between papf.EFFECTIVE_START_DATE
and Nvl(papf.effective_end_date, Sysdate + 1)
and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
and papf.person_id = fu.employee_id)
;
select a.old_project_status_code, a.new_project_status_code
from (select obj_status_change_id,
old_project_status_code,
new_project_status_code
from pa_obj_status_changes
where object_type = 'PA_CI_TYPES'
and object_id = p_ci_id
order by obj_status_change_id desc) a
where rownum = 1;
pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
p_api_version => 1.0
,p_init_msg_list => FND_API.G_TRUE
,p_validate_only => FND_API.G_FALSE
,p_ci_id => l_ci_id
,p_status_code => l_prev_status
,p_record_version_number => NULL
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
select user_name, party_name, email_address
from (
select fu.user_name, hp.party_name, hp.email_address
from fnd_user fu,
hz_parties hp
where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
and hp.party_id = l_owner_id
and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
union
select fu.user_name, hp.party_name, hp.email_address
from fnd_user fu,
hz_parties hp,
per_all_people_f papf
where
--'PER:' || fu.employee_id = hp.orig_system_reference
fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
AND 'PER:' = Substr(hp.orig_system_reference,1,4)
and hp.party_id = l_owner_id
and trunc(sysdate)
between papf.EFFECTIVE_START_DATE
and Nvl(papf.effective_end_date, Sysdate + 1)
and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
and papf.person_id = fu.employee_id)
;
SELECT
owner_id
FROM pa_control_items
WHERE ci_id = l_ci_id;
select user_name, party_name, email_address
from (
select fu.user_name, hp.party_name, hp.email_address
from fnd_user fu,
hz_parties hp
where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
and hp.party_id = l_submitted_by_id
and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
union
select fu.user_name, hp.party_name, hp.email_address
from fnd_user fu,
hz_parties hp,
per_all_people_f papf
where
--'PER:' || fu.employee_id = hp.orig_system_reference
fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
AND 'PER:' = Substr(hp.orig_system_reference,1,4)
and hp.party_id = l_submitted_by_id
and trunc(sysdate)
between papf.EFFECTIVE_START_DATE
and Nvl(papf.effective_end_date, Sysdate + 1)
and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
and papf.person_id = fu.employee_id)
;