APPS.PSP_SUM_TRANS dependencies on PSP_EFF_REPORT_DETAILS

Line 5898: psp_eff_report_details perd

5894: min(pal.summary_line_id) summary_line_id
5895: From psp_adjustment_lines_history pal,
5896: Psp_eff_reports per,
5897: Psp_payroll_controls ppc,
5898: psp_eff_report_details perd
5899: Where pal.distribution_date between per.start_date and per.end_date
5900: and perd.effort_report_id = per.effort_report_id
5901: and perd.assignment_id = pal.assignment_id
5902: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5933: psp_eff_report_details perd

5929: min(pregen.summary_line_id)
5930: From psp_pre_gen_dist_lines_history pregen,
5931: Psp_eff_reports per,
5932: Psp_payroll_controls ppc,
5933: psp_eff_report_details perd
5934: Where pregen.distribution_date between per.start_date and per.end_date
5935: and perd.effort_report_id = per.effort_report_id
5936: and perd.assignment_id = pregen.assignment_id
5937: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5974: psp_eff_report_details perd

5970: Psp_distribution_lines_history DLH,
5971: Psp_payroll_controls ppc,
5972: psp_payroll_sub_lines psub,
5973: psp_payroll_lines ppl,
5974: psp_eff_report_details perd
5975: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5976: and perd.effort_report_id = per.effort_report_id
5977: and perd.assignment_id = ppl.assignment_id
5978: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 6022: psp_eff_report_details perd

6018: Psp_distribution_lines_history DLH,
6019: Psp_payroll_controls ppc,
6020: psp_payroll_sub_lines psub,
6021: psp_payroll_lines ppl,
6022: psp_eff_report_details perd
6023: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
6024: and perd.effort_report_id = per.effort_report_id
6025: and perd.assignment_id = ppl.assignment_id
6026: And per.request_id in (select -person_id from psp_supercede_persons_gt)

Line 6061: psp_eff_report_details perd

6057: pregen.summary_line_id summary_line_id
6058: From psp_pre_gen_dist_lines_history pregen,
6059: Psp_eff_reports per,
6060: Psp_payroll_controls ppc,
6061: psp_eff_report_details perd
6062: Where pregen.distribution_date between per.start_date and per.end_date
6063: and perd.effort_report_id = per.effort_report_id
6064: and perd.assignment_id = pregen.assignment_id
6065: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

Line 6222: psp_eff_report_details erd,

6218:
6219: cursor get_app_wf_names is
6220: select distinct era.wf_role_name
6221: from psp_eff_report_approvals era,
6222: psp_eff_report_details erd,
6223: psp_eff_reports er,
6224: psp_report_templates_h h
6225: where erd.effort_report_detail_id = era.effort_report_detail_id
6226: and erd.effort_report_id = er.effort_report_id

Line 6673: from psp_eff_report_details erd,

6669: if l_tolerance_amt <> -999 then --- tolerance_amt is not null then
6670: l_sql_string := ' begin
6671: select distinct er.request_id, er.person_id
6672: bulk collect into :reqtable, :pertable
6673: from psp_eff_report_details erd,
6674: psp_supercede_persons_gt gt,
6675: psp_eff_reports er
6676: where er.status_code not in
6677: ('||''''||'S'||''''||','||''''||'R'||''''||')

Line 6727: from psp_eff_report_details erd,

6723: else
6724: l_sql_string := ' begin
6725: select distinct er.request_id, er.person_id
6726: bulk collect into :reqtable, :pertable
6727: from psp_eff_report_details erd,
6728: psp_supercede_persons_gt gt,
6729: psp_eff_reports er
6730: where er.status_code not in
6731: ('||''''||'S'||''''||','||''''||'R'||''''||')