APPS.HRI_OPL_MULTI_THREAD dependencies on HRI_ADM_MTHD_RANGES_S

Line 163: select hri_adm_mthd_ranges_s.nextval

159: --
160: IF mod(p_rownum,p_chunk) = 0 OR
161: g_mthd_range_id is null THEN
162: --
163: select hri_adm_mthd_ranges_s.nextval
164: into g_mthd_range_id
165: from dual;
166: --
167: END IF;

Line 1519: FROM hri_adm_mthd_ranges sub

1515: WHERE status = 'UNPROCESSED'
1516: AND mthd_action_id = p_mthd_action_id
1517: AND mthd_range_id =
1518: (SELECT MIN(sub.mthd_range_id)
1519: FROM hri_adm_mthd_ranges sub
1520: WHERE sub.status = 'UNPROCESSED'
1521: AND sub.mthd_action_id = p_mthd_action_id)
1522: RETURNING
1523: mthd_range_id