APPS.BEN_CWB_POST_PROCESS dependencies on BEN_CWB_RPT_DETAIL

Line 225: ben_cwb_rpt_detail rpt,

221: rpt.pl_id,
222: group_oipl.oipl_id group_oipl_id,
223: rpt.person_id
224: FROM ben_oipl_f o,
225: ben_cwb_rpt_detail rpt,
226: ben_oipl_f local_oipl,
227: ben_opt_f local_opt,
228: ben_opt_f group_opt,
229: ben_oipl_f group_oipl

Line 239: FROM ben_cwb_rpt_detail

235: AND group_opt.group_opt_id = local_opt.group_opt_id
236: AND group_oipl.opt_id = group_opt.group_opt_id
237: AND NOT EXISTS
238: (SELECT NULL
239: FROM ben_cwb_rpt_detail
240: WHERE oipl_id = o.oipl_id
241: AND benefit_action_id = v_benefit_action_id)
242: GROUP BY o.oipl_id,
243: rpt.group_per_in_ler_id,

Line 404: FROM ben_cwb_rpt_detail

400:
401: CURSOR c_error_per_summary (v_benefit_action_id IN NUMBER)
402: IS
403: SELECT COUNT (*) amount
404: FROM ben_cwb_rpt_detail
405: WHERE person_rate_id = -9999
406: AND status_cd = 'E'
407: AND benefit_action_id = v_benefit_action_id;
408:

Line 412: FROM ben_cwb_rpt_detail

408:
409: CURSOR c_succ_per_summary (v_benefit_action_id IN NUMBER)
410: IS
411: SELECT COUNT (*) amount
412: FROM ben_cwb_rpt_detail
413: WHERE person_rate_id = -9999
414: AND status_cd IN ('WC', 'SC', 'W')
415: AND benefit_action_id = v_benefit_action_id;
416:

Line 420: FROM ben_cwb_rpt_detail

416:
417: CURSOR c_lf_evt_open_summary (v_benefit_action_id IN NUMBER)
418: IS
419: SELECT COUNT (*) amount
420: FROM ben_cwb_rpt_detail
421: WHERE person_rate_id = -9999
422: AND lf_evt_closed_flag = 'N'
423: AND benefit_action_id = v_benefit_action_id;
424:

Line 428: FROM ben_cwb_rpt_detail

424:
425: CURSOR c_lf_evt_close_summary (v_benefit_action_id IN NUMBER)
426: IS
427: SELECT COUNT (*) amount
428: FROM ben_cwb_rpt_detail
429: WHERE person_rate_id = -9999
430: AND lf_evt_closed_flag = 'Y'
431: AND benefit_action_id = v_benefit_action_id;
432:

Line 1654: INSERT INTO ben_cwb_rpt_detail

1650: g_cache_cwb_rpt_person (i).amount = 0) THEN
1651: g_cache_cwb_rpt_person (i).prev_sal := null;
1652: g_cache_cwb_rpt_person (i).new_sal := null;
1653: END IF;*/
1654: INSERT INTO ben_cwb_rpt_detail
1655: (benefit_action_id
1656: , person_rate_id
1657: , pl_id
1658: , person_id

Line 1845: , ben_cwb_rpt_detail_s.NEXTVAL

1841: , g_cache_cwb_rpt_person (i).assignment_changed
1842: , g_cache_cwb_rpt_person (i).status
1843: , g_cache_cwb_rpt_person (i).lf_evt_closed
1844: , l_message_text
1845: , ben_cwb_rpt_detail_s.NEXTVAL
1846: , g_cache_cwb_rpt_person (i).base_salary_currency
1847: , g_cache_cwb_rpt_person (i).currency
1848: , 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,
1849: nvl(g_cache_cwb_rpt_person (i).uom_precision,2))

Line 1990: INSERT INTO ben_cwb_rpt_detail

1986: IF l_previous <> g_cache_cwb_rpt_person (i).person_id
1987: THEN
1988: l_previous := g_cache_cwb_rpt_person (i).person_id;
1989:
1990: INSERT INTO ben_cwb_rpt_detail
1991: (benefit_action_id
1992: , person_rate_id
1993: , person_id
1994: , country_code

Line 2009: , ben_cwb_rpt_detail_s.NEXTVAL

2005: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_id
2006: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).bg_name
2007: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).status
2008: , g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).lf_evt_closed
2009: , ben_cwb_rpt_detail_s.NEXTVAL
2010: );
2011:
2012: IF (g_cache_cwb_sum_person (g_cache_cwb_rpt_person (i).person_id).status = 'E')
2013: THEN

Line 2056: INSERT INTO ben_cwb_rpt_detail (

2052: BEGIN
2053: WRITE('table corrections');
2054: FOR l_table_correction_rec IN c_table_correction_data(p_benefit_action_id)
2055: LOOP
2056: INSERT INTO ben_cwb_rpt_detail (
2057: benefit_action_id,
2058: person_id,
2059: pl_id,
2060: oipl_id,

Line 2072: ben_cwb_rpt_detail_s.NEXTVAL

2068: l_table_correction_rec.pl_id,
2069: l_table_correction_rec.oipl_id,
2070: l_table_correction_rec.group_per_in_ler_id,
2071: l_table_correction_rec.group_oipl_id,
2072: ben_cwb_rpt_detail_s.NEXTVAL
2073: );
2074: WRITE(
2075: p_benefit_action_id||'-'||
2076: l_table_correction_rec.person_id||'-'||