APPS.PSP_PEE_BUS dependencies on PSP_REPORT_TEMPLATES_H

Line 908: psp_report_templates_h prth

904: IS
905: CURSOR person_effort_report_csr(p_person_id IN NUMBER, p_distribution_date IN DATE) IS
906: SELECT per.effort_report_id, prth.selection_match_level
907: FROM psp_eff_reports per,
908: psp_report_templates_h prth
909: WHERE per.request_id = prth.request_id
910: AND per.PERSON_ID = p_person_id
911: AND p_distribution_date between per.start_date and per.end_date
912: AND per.STATUS_CODE IN ('N','A');

Line 971: psp_report_templates_h prth

967: /*
968: CURSOR person_effort_report_csr(p_person_id IN NUMBER, p_distribution_date IN DATE) IS
969: SELECT per.effort_report_id, prth.selection_match_level
970: FROM psp_eff_reports per,
971: psp_report_templates_h prth
972: WHERE per.request_id = prth.request_id
973: AND per.PERSON_ID = p_person_id
974: AND p_distribution_date between per.start_date and per.end_date
975: AND per.STATUS_CODE IN ('N','A');