2: /* $Header: hriophom.pkh 120.1 2005/08/26 07:12:06 rlpatil noship $ */
3:
4: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5: x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7:
8: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7:
8: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11:
12: FUNCTION CALC_PREV_VALUE(p_supervisor_id NUMBER,
13: p_organization_id NUMBER,
14: p_effective_start_date DATE,