APPS.HRI_OPL_CMNTS_ACTLS_ORGMGR dependencies on HRI_CS_SUPH_ORGMGR_CT

Line 206: ,hri_cs_suph_orgmgr_ct orgmgr

202: ,l_user_id
203: ,l_user_id
204: ,SYSDATE
205: FROM hri_md_cmnts_actls_ct cmntactl
206: ,hri_cs_suph_orgmgr_ct orgmgr
207: WHERE cmntactl.organization_id = orgmgr.sub_organization_id
208: AND orgmgr.sup_person_id = p_person_id;
209: --
210: dbg(SQL%ROWCOUNT||' records inserted into HRI_MDP_CMNTS_ACTLS_ORGMGR_CT');

Line 260: FROM hri_cs_suph_orgmgr_ct

256: IF (g_full_refresh = 'Y') THEN
257: --
258: OPEN c_person_to_process FOR
259: SELECT DISTINCT sup_person_id
260: FROM hri_cs_suph_orgmgr_ct
261: WHERE sup_person_id BETWEEN p_start_object_id and p_end_object_id;
262: --
263: END IF;
264: --

Line 364: FROM hri_cs_suph_orgmgr_ct orgmgr

360: --
361: p_sqlstr :=
362: 'SELECT /*+ parallel (ORGMGR, default, default) */
363: DISTINCT sup_person_id object_id
364: FROM hri_cs_suph_orgmgr_ct orgmgr
365: ORDER BY sup_person_id';
366: --
367: -- End of Full Refresh Section
368: -- -------------------------------------------------------------------------

Line 532: FROM hri_cs_suph_orgmgr_ct

528: max(object_id) end_object_id
529: FROM (SELECT hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
530: ,object_id
531: FROM ( SELECT DISTINCT sup_person_id object_id
532: FROM hri_cs_suph_orgmgr_ct
533: ORDER BY sup_person_id)
534: )
535: GROUP BY mthd_range_id;
536: --