APPS.PSP_UPGRADE_EFF_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 43: per_all_people_f ppf,

39: -- people.full_name approver_name,
40: pert.begin_date, pert.End_date, pbg.name
41: from psp_effort_reports outer,
42: psp_effort_report_templates pert ,
43: per_all_people_f ppf,
44: -- wf_notifications wfis,
45: per_business_groups pbg
46: -- ,
47: -- per_assignments_f assignment,

Line 61: FROM per_all_people_f ppf2

57: and wfas.item_key= outer.effort_report_id || outer.VERSION_NUM)
58: */
59: and outer.person_id =ppf.person_id
60: and ppf.effective_start_date = ( SELECT MAX (ppf2.effective_start_date)
61: FROM per_all_people_f ppf2
62: WHERE ppf.person_id = ppf2.person_id
63: AND ppf2.effective_start_date <=pert.end_date
64: AND ppf2.effective_end_date >= pert.begin_date)
65: -- and pert.begin_date between ppf.effective_start_date and ppf.effective_End_date

Line 95: per_all_people_f ppf,

91: -- people.full_name approver_name,
92: pert.begin_date, pert.end_date , pal.adjustment_batch_name, pbg.name
93: from psp_effort_reports outer,
94: psp_effort_report_templates pert,
95: per_all_people_f ppf,
96: ----wf_notifications wfis,
97: psp_adjustment_control_table pal,
98: per_business_groups pbg
99: -- ,

Line 111: FROM per_all_people_f ppf2

107: and outer.person_id =ppf.person_id
108: and outer.template_id = pert.template_id
109: -- and pert.begin_date between ppf.effective_Start_date and ppf.effective_end_date
110: and ppf.effective_start_date = ( SELECT MAX (ppf2.effective_start_date)
111: FROM per_all_people_f ppf2
112: WHERE ppf.person_id = ppf2.person_id
113: AND ppf2.effective_start_date <=pert.end_date
114: AND ppf2.effective_end_date >= pert.begin_date)
115: and pbg.BUSINESS_GROUP_ID = pert.BUSINESS_GROUP_ID

Line 159: per_all_people_f ppf,

155: -- people.full_name approver_name,
156: pert.begin_date, pert.end_date, pal.adjustment_batch_name, pbg.name
157: from psp_effort_reports outer,
158: psp_effort_report_templates pert,
159: per_all_people_f ppf,
160: ----wf_notifications wfis,
161: psp_adjustment_control_table pal,
162: psp_payroll_controls ppc,
163: per_business_groups pbg

Line 178: FROM per_all_people_f ppf2

174: and outer.person_id =ppf.person_id
175: and outer.template_id = pert.template_id
176: -- and pert.begin_date between ppf.effective_Start_date and ppf.effective_end_date
177: and ppf.effective_start_date = ( SELECT MAX (ppf2.effective_start_date)
178: FROM per_all_people_f ppf2
179: WHERE ppf.person_id = ppf2.person_id
180: AND ppf2.effective_start_date <=pert.end_date
181: AND ppf2.effective_end_date >= pert.begin_date)
182: and pbg.BUSINESS_GROUP_ID = pert.BUSINESS_GROUP_ID