APPS.BEN_MAINTAIN_BENEFIT_ACTIONS dependencies on BEN_BATCH_RANGES

Line 19: select /*+ index(ran BEN_BATCH_RANGES_CK) */

15: cursor c_range_thread
16: (c_bft_id number
17: )
18: is
19: select /*+ index(ran BEN_BATCH_RANGES_CK) */
20: ran.rowid,
21: ran.starting_person_action_id,
22: ran.ending_person_action_id
23: from ben_batch_ranges ran

Line 23: from ben_batch_ranges ran

19: select /*+ index(ran BEN_BATCH_RANGES_CK) */
20: ran.rowid,
21: ran.starting_person_action_id,
22: ran.ending_person_action_id
23: from ben_batch_ranges ran
24: where ran.range_status_cd = 'U'
25: and ran.benefit_action_id = c_bft_id
26: and rownum < 2
27: for update of ran.range_status_cd;

Line 45: update ben_batch_ranges ran

41: if c_range_thread%found then
42: --
43: p_rows_found := true;
44: --
45: update ben_batch_ranges ran
46: set ran.range_status_cd = 'P'
47: where ran.rowid = l_rowid;
48: --
49: end if;