APPS.PSP_UPGRADE_EFF_REPORTS dependencies on PSP_EFFORT_REPORTS

Line 41: from psp_effort_reports outer,

37: CURSOR effort_master_csr IS
38: select outer.effort_report_id, outer.person_id, ppf.full_name,
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

Line 93: from psp_effort_reports outer,

89: CURSOR pending_da_csr is
90: select effort_report_id, outer.person_id, ppf.full_name ,
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,

Line 157: from psp_effort_reports outer,

153: CURSOR pending_summ_trans_csr is
154: select effort_report_id, outer.person_id, ppf.full_name ,
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,