APPS.PSP_EFF_REPORT_DETAILS_API dependencies on PSP_EFF_REPORTS

Line 60: psp_eff_reports per

56: INVESTIGATOR_NAME ,
57: INVESTIGATOR_ORG_NAME ,
58: INVESTIGATOR_PRIMARY_ORG_ID
59: from psp_eff_report_details perd,
60: psp_eff_reports per
61: where REQUEST_ID = p_Request_id
62: and perd.EFFORT_REPORT_ID = per.EFFORT_REPORT_ID
63: and person_id between p_start_person and p_end_person;
64: /* Added Person Id check for Bug fix 4089645 */

Line 70: psp_eff_reports per

66: /*
67: CURSOR c_MAX_PROPOSED_EFFORT_PERCENT IS
68: select per.PERSON_ID,max(Full_name), sum(perd.PROPOSED_EFFORT_PERCENT)
69: from psp_eff_report_details perd,
70: psp_eff_reports per
71: where perd.EFFORT_REPORT_ID = per.EFFORT_REPORT_ID
72: group by per.PERSON_ID
73: having sum(PROPOSED_EFFORT_PERCENT) > 100;
74: CURSOR c_RAnge_PROPOSED_EFFORT_PER IS

Line 77: psp_eff_reports per

73: having sum(PROPOSED_EFFORT_PERCENT) > 100;
74: CURSOR c_RAnge_PROPOSED_EFFORT_PER IS
75: select per.PERSON_ID,max(Full_name), sum(perd.PROPOSED_EFFORT_PERCENT)
76: from psp_eff_report_details perd,
77: psp_eff_reports per
78: where perd.EFFORT_REPORT_ID = per.EFFORT_REPORT_ID
79: --AND (PROPOSED_EFFORT_PERCENT <0
80: --or PROPOSED_EFFORT_PERCENT >100)
81: AND PROPOSED_EFFORT_PERCENT >100