76: where ELEMENT_SET_NAME = p_element_set_name;
77:
78: CURSOR element_striped_by_bg_csr is
79: SELECT DISTINCT business_group_id
80: from psp_effort_report_elements;
81:
82: Cursor effort_element_csr(l_business_group_id IN NUMBER) is
83: select distinct element_type_id
84: from psp_effort_report_elements
80: from psp_effort_report_elements;
81:
82: Cursor effort_element_csr(l_business_group_id IN NUMBER) is
83: select distinct element_type_id
84: from psp_effort_report_elements
85: where use_in_effort_report='Y'
86: and business_group_id =l_business_group_id;
87:
88: