DBA Data[Home] [Help]

APPS.PSP_UPGRADE_EFF_REPORTS dependencies on PSP_EFFORT_REPORT_ELEMENTS

Line 80: from psp_effort_report_elements;

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

Line 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: