APPS.HRI_OPL_WRKFC_EVT_MGRH dependencies on HRI_CS_MNGRSC_CT

Line 478: hri_cs_mngrsc_ct chn

474: ,fct.employee_ind
475: ,fct.contingent_ind
476: ,fct.adt_pow_band
477: FROM
478: hri_cs_mngrsc_ct chn
479: ,hri_cs_suph suph
480: ,hri_mds_wrkfc_mgrh_c01_ct fct
481: WHERE chn.mgrs_person_fk = p_manager_id
482: AND p_snapshot_date BETWEEN chn.mgrs_date_start

Line 541: hri_cs_mngrsc_ct chn

537: ,wevt.employee_ind employee_ind
538: ,wevt.contingent_ind contingent_ind
539: ,wevt.adt_pow_band adt_pow_band
540: FROM
541: hri_cs_mngrsc_ct chn
542: ,hri_mds_wrkfc_mnth_ct wevt
543: ,hri_cs_geo_lochr_ct ctr
544: ,hri_cs_jobh_ct jobh
545: ,hri_cs_prsntyp_ct ptyp

Line 756: hri_cs_mngrsc_ct mgr

752: SELECT DISTINCT
753: mgr.mgrs_person_fk manager_id
754: ,mnth.end_date snapshot_date
755: FROM
756: hri_cs_mngrsc_ct mgr
757: ,hri_cl_wkr_sup_status_ct stt
758: ,(SELECT
759: month.month_id
760: ,add_months(to_date(SUBSTR(to_char(month.month_id), 1, 4) || '-' ||

Line 805: ,hri_cs_mngrsc_ct mgr

801: mgr.mgrs_person_fk manager_id
802: ,mnth.end_date snapshot_date
803: FROM
804: hri_eq_wrkfc_evt_mgrh eq
805: ,hri_cs_mngrsc_ct mgr
806: ,hri_cl_wkr_sup_status_ct stt
807: ,(SELECT
808: month.month_id
809: ,add_months(to_date(SUBSTR(to_char(month.month_id), 1, 4) || '-' ||

Line 841: ,hri_cs_mngrsc_ct mgr

837: (SELECT /*+ ORDERED */
838: snp2.rowid
839: FROM
840: hri_eq_wrkfc_evt_mgrh eq
841: ,hri_cs_mngrsc_ct mgr
842: ,hri_mds_wrkfc_mgrh_c01_ct snp2
843: WHERE eq.sup_person_id = snp2.sup_person_fk
844: AND eq.sup_person_id = mgr.mgrs_person_fk
845: AND mgr.mgrs_level = p_mthd_range_lvl

Line 995: hri_cs_mngrsc_ct mgr

991: 'SELECT /*+ PARALLEL(mgr, default, default) */ DISTINCT
992: mgr.mgrs_person_fk object_id
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

Line 1017: ,hri_cs_mngrsc_ct mgr

1013: mgr.mgrs_person_fk object_id
1014: ,mgr.mgrs_level object_lvl
1015: FROM
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)

Line 1103: hri_cs_mngrsc_ct mgr

1099: (SELECT /*+ PARALLEL(mgr, default, default) */ DISTINCT
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