APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_BATCH_RANGES

Line 1756: FROM ben_batch_ranges ran

1752: CURSOR c_range_for_thread (v_benefit_action_id IN NUMBER)
1753: IS
1754: SELECT ran.range_id, ran.starting_person_action_id,
1755: ran.ending_person_action_id
1756: FROM ben_batch_ranges ran
1757: WHERE ran.range_status_cd = 'U'
1758: AND ran.benefit_action_id = v_benefit_action_id
1759: AND ROWNUM < 2
1760: FOR UPDATE OF ran.range_status_cd;

Line 1873: 'Marking ben_batch_ranges for range_id '

1869: || l_end_person_action_id
1870: || ' is selected'
1871: );
1872: g_actn :=
1873: 'Marking ben_batch_ranges for range_id '
1874: || l_range_id
1875: || ' as processed...';
1876: WRITE (g_actn);
1877:

Line 1878: UPDATE ben_batch_ranges ran

1874: || l_range_id
1875: || ' as processed...';
1876: WRITE (g_actn);
1877:
1878: UPDATE ben_batch_ranges ran
1879: SET ran.range_status_cd = 'P'
1880: WHERE ran.range_id = l_range_id;
1881:
1882: COMMIT;

Line 2066: WRITE ( 'Time before inserting ben batch ranges '

2062: p_perd_id (l_count),
2063: p_bg_id (l_count),
2064: 1);
2065:
2066: WRITE ( 'Time before inserting ben batch ranges '
2067: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
2068:
2069: INSERT INTO ben_batch_ranges
2070: (range_id,

Line 2069: INSERT INTO ben_batch_ranges

2065:
2066: WRITE ( 'Time before inserting ben batch ranges '
2067: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
2068:
2069: INSERT INTO ben_batch_ranges
2070: (range_id,
2071: benefit_action_id,
2072: range_status_cd,
2073: starting_person_action_id,

Line 2077: ben_batch_ranges_s.NEXTVAL,

2073: starting_person_action_id,
2074: ending_person_action_id,
2075: object_version_number)
2076: VALUES (
2077: ben_batch_ranges_s.NEXTVAL,
2078: p_benefit_action_id,
2079: 'U',
2080: p_per_actn_id_array (1),
2081: p_per_actn_id_array (l_num_rows),