DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on HRI_MTDT_DIM_LVL

Line 815: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

811: ,NVL(trn.comp_separation_hdc, 0) comp_termination_hdc
812: ,:HRI_CURR_TERM_HDC curr_total_term_hdc
813: ,:HRI_PREV_TERM_HDC comp_total_term_hdc
814: FROM
815: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
816: (l_parameter_rec.view_by).viewby_table || ' cl
817: ,(' || l_wcnt_chg_fact_sql || ') trn
818: ,(' || l_wrkfc_fact_sql || ') wmv
819: WHERE cl.id = wmv.vby_id' || l_outer_join || '

Line 843: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

839: ,NVL(trn.comp_separation_hdc, 0) comp_termination_hdc
840: ,:HRI_CURR_TERM_HDC curr_total_term_hdc
841: ,:HRI_PREV_TERM_HDC comp_total_term_hdc
842: FROM
843: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
844: (l_parameter_rec.view_by).viewby_table || ' cl
845: ,(' || l_wcnt_chg_fact_sql || ') trn
846: WHERE cl.id = trn.vby_id ' || l_outer_join || g_rtn ||
847: l_view_by_filter ||