APPS.FII_GL_EXPENSE_PKG dependencies on HRI_MDP_SUP_WMV_SUP_MV

Line 75: from hri_mdp_sup_wmv_sup_mv

71: -- -------------------------------------------------
72: --query below gets the headcount for the reporting date
73: begin
74: select total_headcount+1 into fii_gl_util_pkg.g_total_hc
75: from hri_mdp_sup_wmv_sup_mv
76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
77: and effective_start_date = (SELECT max(aa.effective_start_date)
78: FROM hri_mdp_sup_wmv_sup_mv aa
79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id

Line 78: FROM hri_mdp_sup_wmv_sup_mv aa

74: select total_headcount+1 into fii_gl_util_pkg.g_total_hc
75: from hri_mdp_sup_wmv_sup_mv
76: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
77: and effective_start_date = (SELECT max(aa.effective_start_date)
78: FROM hri_mdp_sup_wmv_sup_mv aa
79: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
80: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_as_of_date, sysdate));
81: exception
82: when others then

Line 89: from hri_mdp_sup_wmv_sup_mv

85:
86: --query below gets the headcount as of the prior reporting date
87: begin
88: select total_headcount+1 into l_total_prior_hc
89: from hri_mdp_sup_wmv_sup_mv
90: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
91: and effective_start_date = (SELECT max(aa.effective_start_date)
92: FROM hri_mdp_sup_wmv_sup_mv aa
93: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id

Line 92: FROM hri_mdp_sup_wmv_sup_mv aa

88: select total_headcount+1 into l_total_prior_hc
89: from hri_mdp_sup_wmv_sup_mv
90: where supervisor_person_id = fii_gl_util_pkg.g_mgr_id
91: and effective_start_date = (SELECT max(aa.effective_start_date)
92: FROM hri_mdp_sup_wmv_sup_mv aa
93: WHERE aa.supervisor_person_id = fii_gl_util_pkg.g_mgr_id
94: AND aa.effective_start_date <= decode(l_shared_hr_flag, 'N', fii_gl_util_pkg.g_previous_asof_date, sysdate));
95: exception
96: when others then

Line 183: hri_mdp_sup_wmv_sup_mv cnt

179: to_number(NULL) PY_HEADCNT,
180: to_number(NULL) CY_XTD,
181: to_number(NULL) PY_XTD
182: FROM fii_cc_mgr_hierarchies mgr,
183: hri_mdp_sup_wmv_sup_mv cnt
184: WHERE mgr.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
185: AND mgr.emp_level = mgr.mgr_level + 1
186: AND cnt.supervisor_person_id = mgr.emp_id
187: AND cnt.effective_start_date = (SELECT /*+ no_unnest*/ MAX(cnt2.effective_start_date)

Line 188: FROM hri_mdp_sup_wmv_sup_mv cnt2

184: WHERE mgr.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
185: AND mgr.emp_level = mgr.mgr_level + 1
186: AND cnt.supervisor_person_id = mgr.emp_id
187: AND cnt.effective_start_date = (SELECT /*+ no_unnest*/ MAX(cnt2.effective_start_date)
188: FROM hri_mdp_sup_wmv_sup_mv cnt2
189: WHERE cnt.supervisor_person_id = cnt2.supervisor_person_id
190: AND cnt2.effective_start_date <= decode('''||l_shared_hr_flag||''', ''N'', &BIS_CURRENT_ASOF_DATE, sysdate))
191: AND cnt.total_headcount > 0
192: UNION ALL

Line 199: hri_mdp_sup_wmv_sup_mv cnt

195: NVL(cnt.total_headcount,0) PY_HEADCNT,
196: to_number(NULL) CY_XTD,
197: to_number(NULL) PY_XTD
198: FROM fii_cc_mgr_hierarchies mgr,
199: hri_mdp_sup_wmv_sup_mv cnt
200: WHERE mgr.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
201: AND mgr.emp_level = mgr.mgr_level + 1
202: AND cnt.supervisor_person_id = mgr.emp_id
203: AND cnt.effective_start_date = (SELECT /*+ no_unnest*/ MAX(cnt2.effective_start_date)

Line 204: FROM hri_mdp_sup_wmv_sup_mv cnt2

200: WHERE mgr.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
201: AND mgr.emp_level = mgr.mgr_level + 1
202: AND cnt.supervisor_person_id = mgr.emp_id
203: AND cnt.effective_start_date = (SELECT /*+ no_unnest*/ MAX(cnt2.effective_start_date)
204: FROM hri_mdp_sup_wmv_sup_mv cnt2
205: WHERE cnt.supervisor_person_id = cnt2.supervisor_person_id
206: AND cnt2.effective_start_date <= decode('''||l_shared_hr_flag||''', ''N'', &BIS_PREVIOUS_ASOF_DATE, sysdate))
207: AND cnt.total_headcount > 0
208: UNION ALL