APPS.HRI_OPL_WRKFC_EVT_ORGH dependencies on HRI_CS_ORGH_CT

Line 479: hri_cs_orgh_ct orgh

475: ,fct.employee_ind
476: ,fct.contingent_ind
477: ,fct.adt_pow_band
478: FROM
479: hri_cs_orgh_ct orgh
480: ,hri_mds_wrkfc_orgh_c01_ct fct
481: WHERE orgh.orgh_sup_organztn_fk = p_organization_fk
482: AND orgh.orgh_relative_level = 1
483: AND orgh.orgh_sub_node_has_workers_flag = 'Y'

Line 745: hri_cs_orgh_ct orgh

741: ,add_months(to_date(SUBSTR(to_char(mnth.month_id), 1, 4) || '-' ||
742: SUBSTR(to_char(mnth.month_id), 6, 2), 'YYYY-MM'),
743: 1) - 1 snapshot_date
744: FROM
745: hri_cs_orgh_ct orgh
746: ,fii_time_month mnth
747: WHERE orgh.orgh_relative_level = 0
748: AND mnth.month_id >= to_number(to_char(g_dbi_start_date, 'YYYYQMM'))
749: AND mnth.month_id <= to_number(to_char(g_sysdate, 'YYYYQMM'))

Line 786: ,hri_cs_orgh_ct orgh

782: SUBSTR(to_char(mnth.month_id), 6, 2), 'YYYY-MM'),
783: 1) - 1 snapshot_date
784: FROM
785: hri_eq_wrkfc_evt_orgh eq
786: ,hri_cs_orgh_ct orgh
787: ,fii_time_month mnth
788: WHERE mnth.month_id >= to_number(to_char(eq.erlst_evnt_effective_date, 'YYYYQMM'))
789: AND mnth.month_id >= to_number(to_char(g_dbi_start_date, 'YYYYQMM'))
790: AND mnth.month_id <= to_number(to_char(g_sysdate, 'YYYYQMM'))

Line 806: ,hri_cs_orgh_ct orgh

802: (SELECT /*+ ORDERED */
803: snp2.rowid
804: FROM
805: hri_eq_wrkfc_evt_orgh eq
806: ,hri_cs_orgh_ct orgh
807: ,hri_mds_wrkfc_orgh_c01_ct snp2
808: WHERE eq.organization_id = snp2.sup_organztn_fk
809: AND eq.organization_id BETWEEN p_start_object_id
810: AND p_end_object_id

Line 962: hri_cs_orgh_ct orgh

958: 'SELECT
959: orgh_sup_organztn_fk object_id
960: ,orgh_level object_lvl
961: FROM
962: hri_cs_orgh_ct orgh
963: WHERE orgh.orgh_relative_level = 0
964: AND orgh.orgh_sub_node_has_workers_flag = ''Y''
965: ORDER BY 2 DESC, 1';
966:

Line 980: hri_cs_orgh_ct orgh

976: 'SELECT
977: orgh.orgh_sup_organztn_fk object_id
978: ,orgh.orgh_level object_lvl
979: FROM
980: hri_cs_orgh_ct orgh
981: ,hri_eq_wrkfc_evt_orgh eq
982: WHERE orgh.orgh_relative_level = 0
983: AND orgh.orgh_sub_node_has_workers_flag = ''Y''
984: AND orgh.orgh_sup_organztn_fk = eq.organization_id

Line 1062: hri_cs_orgh_ct orgh

1058: (SELECT
1059: orgh_sup_organztn_fk object_id
1060: ,orgh_level object_lvl
1061: FROM
1062: hri_cs_orgh_ct orgh
1063: WHERE orgh.orgh_relative_level = 0
1064: AND orgh.orgh_sub_node_has_workers_flag = 'Y'
1065: ORDER BY 2 DESC, 1
1066: )