APPS.HRI_OPL_WRKFC_EVT_MGRH dependencies on HRI_BPL_PARAMETER

Line 134: g_dbi_start_date := hri_bpl_parameter.get_bis_global_start_date;

130: g_refresh_to_date := g_mthd_action_array.collect_to_date;
131: g_full_refresh := g_mthd_action_array.full_refresh_flag;
132: g_sysdate := sysdate;
133: g_user := fnd_global.user_id;
134: g_dbi_start_date := hri_bpl_parameter.get_bis_global_start_date;
135:
136: -- Calculate number of quarters to process
137: l_first_qtr_start_date := trunc(g_dbi_start_date, 'Q');
138: l_last_qtr_start_date := trunc(g_refresh_to_date, 'Q');

Line 997: AND mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date

993: ,mgr.mgrs_level object_lvl
994: FROM
995: hri_cs_mngrsc_ct mgr
996: WHERE mgr.mgrs_person_fk <> -1
997: AND mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date
998: AND mgr.mgrs_date_start <= trunc(sysdate)
999: ORDER BY
1000: mgr.mgrs_level DESC
1001: ,mgr.mgrs_person_fk';

Line 1020: AND mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date

1016: hri_eq_wrkfc_evt_mgrh eq
1017: ,hri_cs_mngrsc_ct mgr
1018: WHERE eq.sup_person_id = mgr.mgrs_person_fk
1019: AND mgr.mgrs_date_end >= eq.erlst_evnt_effective_date
1020: AND mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date
1021: AND mgr.mgrs_date_start <= trunc(sysdate)
1022: ORDER BY
1023: mgr.mgrs_level DESC
1024: ,mgr.mgrs_person_fk';

Line 1104: WHERE mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date

1100: mgr.mgrs_person_fk object_id
1101: ,mgr.mgrs_level object_lvl
1102: FROM
1103: hri_cs_mngrsc_ct mgr
1104: WHERE mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date
1105: AND mgr.mgrs_date_start <= trunc(sysdate))
1106: ORDER BY object_lvl DESC, object_id))
1107: GROUP BY
1108: mthd_range_id

Line 1135: AND qtr.end_date >= hri_bpl_parameter.get_bis_global_start_date

1131: AND qtr.end_date >= eq.erlst_evnt_effective_date
1132: AND mgr.supervisor_flag = 'Y'
1133: AND qtr.end_date BETWEEN mgr.effective_start_date
1134: AND ADD_MONTHS(mgr.effective_end_date, 3)
1135: AND qtr.end_date >= hri_bpl_parameter.get_bis_global_start_date
1136: AND qtr.start_date <= trunc(sysdate)
1137: ORDER BY 1
1138: ) tab
1139: ) chunks

Line 1153: g_dbi_start_date := hri_bpl_parameter.get_bis_global_start_date;

1149:
1150: g_full_refresh := p_full_refresh_flag;
1151: g_refresh_to_date := trunc(sysdate);
1152: g_sysdate := trunc(sysdate);
1153: g_dbi_start_date := hri_bpl_parameter.get_bis_global_start_date;
1154: l_first_qtr_start_date := trunc(g_dbi_start_date, 'Q');
1155: l_last_qtr_start_date := trunc(g_refresh_to_date, 'Q');
1156: g_no_qtrs_to_process := (MONTHS_BETWEEN(l_last_qtr_start_date,
1157: l_first_qtr_start_date) / 3) + 1;