1583: ,g_user
1584: ,g_user
1585: ,g_sysdate
1586: FROM
1587: hri_cs_mngrsc_ct chn
1588: ,hri_cs_mngrsc_ct chn_prv
1589: ,hri_cs_pow_band_ct pow
1590: ,(SELECT /*+ NO_MERGE */
1591: hri_opl_wrkfc_evt_type.get_evtypcmb_fk
1584: ,g_user
1585: ,g_sysdate
1586: FROM
1587: hri_cs_mngrsc_ct chn
1588: ,hri_cs_mngrsc_ct chn_prv
1589: ,hri_cs_pow_band_ct pow
1590: ,(SELECT /*+ NO_MERGE */
1591: hri_opl_wrkfc_evt_type.get_evtypcmb_fk
1592: (assignment_change_ind
2074: ,g_user
2075: ,g_user
2076: ,g_sysdate
2077: FROM
2078: hri_cs_mngrsc_ct chn
2079: ,hri_cs_mngrsc_ct chn_prv
2080: ,hri_cs_pow_band_ct pow
2081: ,(SELECT /*+ NO_MERGE */
2082: hri_opl_wrkfc_evt_type.get_evtypcmb_fk
2075: ,g_user
2076: ,g_sysdate
2077: FROM
2078: hri_cs_mngrsc_ct chn
2079: ,hri_cs_mngrsc_ct chn_prv
2080: ,hri_cs_pow_band_ct pow
2081: ,(SELECT /*+ NO_MERGE */
2082: hri_opl_wrkfc_evt_type.get_evtypcmb_fk
2083: (assignment_change_ind