APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_CWB_RPT_DETAIL

Line 80: ben_cwb_rpt_detail rpt,

76: rpt.pl_id,
77: group_oipl.oipl_id group_oipl_id,
78: rpt.person_id
79: FROM ben_oipl_f o,
80: ben_cwb_rpt_detail rpt,
81: ben_oipl_f local_oipl,
82: ben_opt_f local_opt,
83: ben_opt_f group_opt,
84: ben_oipl_f group_oipl

Line 94: FROM ben_cwb_rpt_detail

90: AND group_opt.group_opt_id = local_opt.group_opt_id
91: AND group_oipl.opt_id = group_opt.group_opt_id
92: AND NOT EXISTS
93: (SELECT NULL
94: FROM ben_cwb_rpt_detail
95: WHERE oipl_id = o.oipl_id
96: AND benefit_action_id = v_benefit_action_id)
97: GROUP BY o.oipl_id,
98: rpt.group_per_in_ler_id,

Line 204: FROM ben_cwb_rpt_detail

200:
201: CURSOR c_error_per_summary (v_benefit_action_id IN NUMBER)
202: IS
203: SELECT COUNT (*) amount
204: FROM ben_cwb_rpt_detail
205: WHERE person_rate_id = -9999
206: AND status_cd = 'E'
207: AND benefit_action_id = v_benefit_action_id;
208:

Line 212: FROM ben_cwb_rpt_detail

208:
209: CURSOR c_succ_per_summary (v_benefit_action_id IN NUMBER)
210: IS
211: SELECT COUNT (*) amount
212: FROM ben_cwb_rpt_detail
213: WHERE person_rate_id = -9999
214: AND status_cd IN ('WC', 'SC', 'W')
215: AND benefit_action_id = v_benefit_action_id;
216:

Line 220: FROM ben_cwb_rpt_detail

216:
217: CURSOR c_lf_evt_open_summary (v_benefit_action_id IN NUMBER)
218: IS
219: SELECT COUNT (*) amount
220: FROM ben_cwb_rpt_detail
221: WHERE person_rate_id = -9999
222: AND lf_evt_closed_flag = 'N'
223: AND benefit_action_id = v_benefit_action_id;
224:

Line 228: FROM ben_cwb_rpt_detail

224:
225: CURSOR c_lf_evt_close_summary (v_benefit_action_id IN NUMBER)
226: IS
227: SELECT COUNT (*) amount
228: FROM ben_cwb_rpt_detail
229: WHERE person_rate_id = -9999
230: AND lf_evt_closed_flag = 'Y'
231: AND benefit_action_id = v_benefit_action_id;
232:

Line 1431: INSERT INTO ben_cwb_rpt_detail

1427: g_cache_cwb_rpt_person (i).amount = 0) THEN
1428: g_cache_cwb_rpt_person (i).prev_sal := null;
1429: g_cache_cwb_rpt_person (i).new_sal := null;
1430: END IF;*/
1431: INSERT INTO ben_cwb_rpt_detail
1432: (benefit_action_id
1433: , person_rate_id
1434: , pl_id
1435: , person_id

Line 1622: , ben_cwb_rpt_detail_s.NEXTVAL

1618: , g_cache_cwb_rpt_person (i).assignment_changed
1619: , g_cache_cwb_rpt_person (i).status
1620: , g_cache_cwb_rpt_person (i).lf_evt_closed
1621: , l_message_text
1622: , ben_cwb_rpt_detail_s.NEXTVAL
1623: , g_cache_cwb_rpt_person (i).base_salary_currency
1624: , g_cache_cwb_rpt_person (i).currency
1625: , round(g_cache_cwb_rpt_person (i).base_salary*g_cache_cwb_rpt_person (i).pay_ann_factor/g_cache_cwb_rpt_person (i).pl_ann_factor,
1626: nvl(g_cache_cwb_rpt_person (i).uom_precision,2))

Line 1767: INSERT INTO ben_cwb_rpt_detail

1763: IF l_previous <> g_cache_cwb_rpt_person (i).person_id
1764: THEN
1765: l_previous := g_cache_cwb_rpt_person (i).person_id;
1766:
1767: INSERT INTO ben_cwb_rpt_detail
1768: (benefit_action_id
1769: , person_rate_id
1770: , person_id
1771: , country_code

Line 1786: , ben_cwb_rpt_detail_s.NEXTVAL

1782: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_id
1783: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_name
1784: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).status
1785: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).lf_evt_closed
1786: , ben_cwb_rpt_detail_s.NEXTVAL
1787: );
1788:
1789: IF (g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).status = 'E')
1790: THEN

Line 1838: INSERT INTO ben_cwb_rpt_detail (

1834: BEGIN
1835: WRITE('table corrections');
1836: FOR l_table_correction_rec IN c_table_correction_data(p_benefit_action_id)
1837: LOOP
1838: INSERT INTO ben_cwb_rpt_detail (
1839: benefit_action_id,
1840: person_id,
1841: pl_id,
1842: oipl_id,

Line 1854: ben_cwb_rpt_detail_s.NEXTVAL

1850: l_table_correction_rec.pl_id,
1851: l_table_correction_rec.oipl_id,
1852: l_table_correction_rec.group_per_in_ler_id,
1853: l_table_correction_rec.group_oipl_id,
1854: ben_cwb_rpt_detail_s.NEXTVAL
1855: );
1856: WRITE(
1857: p_benefit_action_id||'-'||
1858: l_table_correction_rec.person_id||'-'||