APPS.PSP_SUM_TRANS dependencies on PSP_EFF_REPORT_DETAILS

Line 5475: psp_eff_report_details perd

5471: min(pal.summary_line_id) summary_line_id
5472: From psp_adjustment_lines_history pal,
5473: Psp_eff_reports per,
5474: Psp_payroll_controls ppc,
5475: psp_eff_report_details perd
5476: Where pal.distribution_date between per.start_date and per.end_date
5477: and perd.effort_report_id = per.effort_report_id
5478: and perd.assignment_id = pal.assignment_id
5479: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5510: psp_eff_report_details perd

5506: min(pregen.summary_line_id)
5507: From psp_pre_gen_dist_lines_history pregen,
5508: Psp_eff_reports per,
5509: Psp_payroll_controls ppc,
5510: psp_eff_report_details perd
5511: Where pregen.distribution_date between per.start_date and per.end_date
5512: and perd.effort_report_id = per.effort_report_id
5513: and perd.assignment_id = pregen.assignment_id
5514: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5551: psp_eff_report_details perd

5547: Psp_distribution_lines_history DLH,
5548: Psp_payroll_controls ppc,
5549: psp_payroll_sub_lines psub,
5550: psp_payroll_lines ppl,
5551: psp_eff_report_details perd
5552: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5553: and perd.effort_report_id = per.effort_report_id
5554: and perd.assignment_id = ppl.assignment_id
5555: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5599: psp_eff_report_details perd

5595: Psp_distribution_lines_history DLH,
5596: Psp_payroll_controls ppc,
5597: psp_payroll_sub_lines psub,
5598: psp_payroll_lines ppl,
5599: psp_eff_report_details perd
5600: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5601: and perd.effort_report_id = per.effort_report_id
5602: and perd.assignment_id = ppl.assignment_id
5603: And per.request_id in (select -person_id from psp_supercede_persons_gt)

Line 5638: psp_eff_report_details perd

5634: pregen.summary_line_id summary_line_id
5635: From psp_pre_gen_dist_lines_history pregen,
5636: Psp_eff_reports per,
5637: Psp_payroll_controls ppc,
5638: psp_eff_report_details perd
5639: Where pregen.distribution_date between per.start_date and per.end_date
5640: and perd.effort_report_id = per.effort_report_id
5641: and perd.assignment_id = pregen.assignment_id
5642: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

Line 5799: psp_eff_report_details erd,

5795:
5796: cursor get_app_wf_names is
5797: select distinct era.wf_role_name
5798: from psp_eff_report_approvals era,
5799: psp_eff_report_details erd,
5800: psp_eff_reports er,
5801: psp_report_templates_h h
5802: where erd.effort_report_detail_id = era.effort_report_detail_id
5803: and erd.effort_report_id = er.effort_report_id

Line 6246: from psp_eff_report_details erd,

6242: if l_tolerance_amt <> -999 then --- tolerance_amt is not null then
6243: l_sql_string := ' begin
6244: select distinct er.request_id, er.person_id
6245: bulk collect into :reqtable, :pertable
6246: from psp_eff_report_details erd,
6247: psp_supercede_persons_gt gt,
6248: psp_eff_reports er
6249: where er.status_code not in
6250: ('||''''||'S'||''''||','||''''||'R'||''''||')

Line 6300: from psp_eff_report_details erd,

6296: else
6297: l_sql_string := ' begin
6298: select distinct er.request_id, er.person_id
6299: bulk collect into :reqtable, :pertable
6300: from psp_eff_report_details erd,
6301: psp_supercede_persons_gt gt,
6302: psp_eff_reports er
6303: where er.status_code not in
6304: ('||''''||'S'||''''||','||''''||'R'||''''||')