APPS.HRI_OLTP_PMV_WMV_SAL_SUP_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 14: PROCEDURE get_sql_ctr2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

10: --* AK SQL For Headcount and Salary by Country Status *
11: --* AK Region : HRI_P_WMV_SAL_CTR_SUP_PVT *
12: --****************************************************************************
13: --
14: PROCEDURE get_sql_ctr2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
15: ,x_custom_sql OUT NOCOPY VARCHAR2
16: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
17: IS
18:

Line 170: PROCEDURE get_sql_rgn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

166: --* AK SQL For Headcount and Salary by Region *
167: --* AK Region : HRI_P_WMV_SAL_RGN_SUP *
168: --****************************************************************************
169: --
170: PROCEDURE get_sql_rgn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
171: ,x_custom_sql OUT NOCOPY VARCHAR2
172: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
173: IS
174:

Line 328: PROCEDURE get_sql_cit2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

324: --* AK SQL For Headcount and Salary by City *
325: --* AK City : HRI_P_WMV_SAL_CIT_SUP *
326: --****************************************************************************
327: --
328: PROCEDURE get_sql_cit2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
329: ,x_custom_sql OUT NOCOPY VARCHAR2
330: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
331: )
332: IS

Line 508: PROCEDURE get_sql_jfm2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

504: --* AK SQL For Headcount and Salary by Job Function *
505: --* AK City : HRI_P_WMV_SAL_JFM_SUP *
506: --****************************************************************************
507: --
508: PROCEDURE get_sql_jfm2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
509: x_custom_sql OUT NOCOPY VARCHAR2,
510: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
511:
512: l_sqltext VARCHAR2(32767) ;

Line 652: PROCEDURE get_sql_jfmfn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

648: --* AK SQL For Headcount and Salary by Job Family *
649: --* AK City : HRI_P_WMV_SAL_JFMFN_SUP *
650: --****************************************************************************
651: --
652: PROCEDURE get_sql_jfmfn2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
653: x_custom_sql OUT NOCOPY VARCHAR2,
654: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
655:
656: l_sqltext VARCHAR2(32767) ;