APPS.PSP_WF_EFT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

SELECT full_name,
       employee_number
FROM per_people_f
WHERE person_id = L_Person_id and
      L_end_perd between effective_start_date and effective_end_date;

Line: 33

SELECT Begin_date,
       End_date
FROM psp_effort_report_templates
WHERE template_id = l_template_id;

Line: 39

SELECT ppf.full_name
FROM per_people_f ppf
WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf
                       where  paf.person_id = l_person_id
                              AND  paf.assignment_type ='E'	--Added for bug 2624259.
                              AND  l_end_perd between paf.effective_start_date and
                                                 paf.effective_end_date   and
                              paf.primary_flag  = 'Y' ) and
      l_end_perd between ppf.effective_start_date and ppf.effective_end_date;

Line: 51

SELECT	usr.user_name
FROM	fnd_user usr,
	per_people_f ppf,
	fnd_languages fndl
WHERE 	usr.employee_id = ppf.person_id
AND     trunc ( SYSDATE ) between ppf.effective_start_date and ppf.effective_end_date
AND     fndl.installed_flag='B'
AND 	usr.end_date IS  NULL
AND 	ppf.person_id  = l_person_id
AND     rownum = 1 ;

Line: 62

SELECT name
FROM   wf_users
where  orig_system_id = l_person_id and
       orig_system    = 'PER' and
       status         = 'ACTIVE' and
       rownum	  = 1;

Line: 81

	SELECT person_id, template_id INTO L_person_id,L_template_id
	FROM psp_effort_reports
--	WHERE effort_report_id = to_number(itemkey); 8.31.99...use the l_itemkey

Line: 205

SELECT full_name,
       employee_number
FROM per_people_f
WHERE person_id = L_Person_id and
      L_end_perd between effective_start_date and effective_end_date;

Line: 212

SELECT Begin_date,
       End_date
FROM psp_effort_report_templates
WHERE template_id = l_template_id;

Line: 218

SELECT ppf.full_name, ppf.person_id
FROM per_people_f ppf
WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf
                       where  paf.person_id = l_person_id
		              AND paf.assignment_type ='E' --Added for bug 2624259.
                              AND l_end_perd between paf.effective_start_date and
                                                 paf.effective_end_date and
		                 primary_flag = 'Y')   and
      l_end_perd between ppf.effective_start_date and ppf.effective_end_date;

Line: 230

SELECT	usr.user_name
FROM	fnd_user usr,
	per_people_f ppf,
	fnd_languages fndl
WHERE 	usr.employee_id = ppf.person_id
AND     trunc ( SYSDATE ) between ppf.effective_start_date and ppf.effective_end_date
AND     fndl.installed_flag='B'
AND 	usr.end_date IS NULL
AND 	ppf.person_id  = l_supervisor_id
AND     rownum = 1 ;

Line: 241

SELECT name
FROM   wf_users
where  orig_system_id = l_supervisor_id and
       orig_system    = 'PER' and
       status         = 'ACTIVE';

Line: 257

	SELECT person_id, template_id INTO L_person_id, l_template_id
	FROM psp_effort_reports
--8.31.99 ....use the l_itemkey above...BUG#969850
--	WHERE effort_report_id = to_number(itemkey);