[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pprv.*, pl.meaning progress_status FROM
pa_progress_reports_v pprv,
pa_lookups pl
where lookup_type like 'PROGRESS_SYSTEM_STATUS'
AND pl.lookup_code = pprv.progress_status_code
and pprv.version_id = p_version_id;
select papf.full_name
from
per_all_people_f papf
WHERE
papf.person_id = l_person_id;
SELECT fu.user_name
from
per_all_people_f papf, fnd_user fu
WHERE
fu.user_id = l_usr_id
and
fu.employee_id = papf.person_id;
select UNIQUE usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
from per_all_people_f papf,
fnd_user usr
WHERE
papf.person_id = usr.employee_id
and trunc(sysdate)
between papf.EFFECTIVE_START_DATE
and Nvl(papf.effective_end_date, Sysdate + 1)
and trunc(sysdate) between USR.START_DATE and nvl(USR.END_DATE, sysdate+1)
AND usr.user_id = l_user_id;
select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
usr.user_name,papf.email_address,papf.full_name person_name
from per_all_people_f papf,
fnd_user usr,
pa_project_parties ppp
WHERE
papf.person_id = usr.employee_id
and trunc(sysdate)
between papf.EFFECTIVE_START_DATE
and Nvl(papf.effective_end_date, Sysdate + 1)
and trunc(sysdate) between USR.START_DATE and nvl(USR.END_DATE, sysdate+1)
and papf.person_id = ppp.resource_source_id
and ppp.resource_type_id <> 112 -- skkoppul addd for bug 9033874
and ppp.object_id = l_project_id
and ppp.object_type = 'PA_PROJECTS';
SELECT popl.approval_required
FROM pa_object_page_layouts popl, pa_progress_report_vers pprv
WHERE pprv.version_id = p_version_id
AND popl.object_id = pprv.object_id
AND popl.object_type = pprv.object_type
AND popl.page_id = pprv.page_id
and popl.report_type_id = pprv.report_type_id;
SELECT
customer_name,
person_name,
carrying_out_organization_name
FROM pa_project_lists_v
WHERE project_id = l_project_id;
select resource_source_id from pa_project_parties
where object_id = l_project_id
and object_type = 'PA_PROJECTS'
and resource_id = l_resource_id;
, 'LAST_UPDATED_BY'
, rec.last_updated_by);
select count(1) into l_doc_attach_count
from FND_ATTACHED_DOCUMENTS
WHERE entity_name = 'PA_PROGRESS_REPORTS'
and PK1_Value = p_version_id;
SELECT user_name
FROM fnd_user
WHERE user_id = FND_GLOBAL.user_id;
select distinct
fu.user_id,
fu.user_name,
papf.email_address,
papf.full_name person_name
from
fnd_user fu,per_all_people_f papf
where
fu.employee_id = l_approver_id
and papf.person_id = fu.employee_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+1)
;
select distinct
fu.user_id,
fu.user_name,
papf.email_address,
papf.full_name person_name
from
fnd_user fu,per_all_people_f papf
where
fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
and papf.person_id = fu.employee_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+1)
;
select approver_source_id,
approver_source_type
from pa_progress_report_vers pprv,
pa_object_page_layouts popl
where pprv.object_id = popl.object_id
and pprv.object_type = popl.object_type
and pprv.report_type_id = popl.report_type_id
and version_id = l_version_id;
SELECT DISTINCT
fu.user_name,
p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
FROM per_assignments_f p1, per_all_people_f p2
, fnd_user fu
WHERE p1.person_id = l_reported_by_id
and p1.supervisor_id = p2.person_id
AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451
AND p1.primary_flag ='Y' -- Added for bug 2911451
AND TRUNC(sysdate) BETWEEN p1.EFFECTIVE_START_DATE
AND p1.EFFECTIVE_END_DATE -- Removed null for bug 2911451
AND TRUNC(sysdate) BETWEEN p2.EFFECTIVE_START_DATE
AND NVL(p2.EFFECTIVE_END_DATE, sysdate)
AND fu.employee_id = p1.supervisor_id
;
select name,expiration_date from wf_local_roles where name = l_approval_role;
-- if no approver select from setup
CLOSE get_approver_source_id;
select popl.object_page_layout_id
from pa_object_page_layouts popl,
pa_progress_report_vers pprv
where popl.object_id = l_project_id
and popl.object_type = 'PA_PROJECTS'
and popl.page_type_code = 'PPR'
and sysdate between popl.effective_from and nvl(popl.effective_to, sysdate+1)
and pprv.version_id = l_version_id
and pprv.report_type_id = popl.report_type_id;
SELECT
usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
FROM pa_project_lists_v pplv,
per_all_people_f papf,
fnd_user usr
WHERE pplv.project_id = l_project_id
and papf.person_id = usr.employee_id
and trunc(sysdate)
between papf.EFFECTIVE_START_DATE
and Nvl(papf.effective_end_date, Sysdate + 1)
and trunc(sysdate) between USR.START_DATE and nvl(USR.END_DATE, sysdate+1)
and papf.person_id = pplv.person_id;