APPS.PSP_PEE_BUS dependencies on PSP_EFF_REPORT_DETAILS

Line 916: FROM psp_eff_report_details perd

912: AND per.STATUS_CODE IN ('N','A');
913:
914: CURSOR assignment_effort_report_csr (p_effort_report_id IN NUMBER, p_assignment_id IN NUMBER) IS
915: SELECT assignment_id
916: FROM psp_eff_report_details perd
917: WHERE effort_report_id = p_effort_report_id
918: AND ASSIGNMENT_ID = p_assignment_id;
919: --
920: l_effort_report_id NUMBER;

Line 979: FROM psp_eff_report_details perd

975: AND per.STATUS_CODE IN ('N','A');
976:
977: CURSOR assignment_effort_report_csr (p_effort_report_id IN NUMBER, p_assignment_id IN NUMBER) IS
978: SELECT assignment_id
979: FROM psp_eff_report_details perd
980: WHERE effort_report_id = p_effort_report_id
981: AND ASSIGNMENT_ID = p_assignment_id;
982: */
983: CURSOR business_group_csr(p_business_group_id IN NUMBER, p_distribution_date IN DATE) IS