eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_CWB_PL_DSGN

Line 42: plan ben_cwb_pl_dsgn.pl_id%type,

38: --
39: -- Global cursor and variables declaration
40: --
41: TYPE plan_override_date IS RECORD (
42: plan ben_cwb_pl_dsgn.pl_id%type,
43: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
44:
45: TYPE g_override_date_t IS TABLE OF plan_override_date;
46:

Line 43: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);

39: -- Global cursor and variables declaration
40: --
41: TYPE plan_override_date IS RECORD (
42: plan ben_cwb_pl_dsgn.pl_id%type,
43: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
44:
45: TYPE g_override_date_t IS TABLE OF plan_override_date;
46:
47: TYPE plan_abr_info IS RECORD (

Line 48: pl_id ben_cwb_pl_dsgn.pl_id%type,

44:
45: TYPE g_override_date_t IS TABLE OF plan_override_date;
46:
47: TYPE plan_abr_info IS RECORD (
48: pl_id ben_cwb_pl_dsgn.pl_id%type,
49: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
50: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
51: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
52:

Line 49: oipl_id ben_cwb_pl_dsgn.oipl_id%type,

45: TYPE g_override_date_t IS TABLE OF plan_override_date;
46:
47: TYPE plan_abr_info IS RECORD (
48: pl_id ben_cwb_pl_dsgn.pl_id%type,
49: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
50: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
51: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
52:
53: TYPE g_abr_info_t IS TABLE OF plan_abr_info;

Line 50: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,

46:
47: TYPE plan_abr_info IS RECORD (
48: pl_id ben_cwb_pl_dsgn.pl_id%type,
49: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
50: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
51: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
52:
53: TYPE g_abr_info_t IS TABLE OF plan_abr_info;
54:

Line 51: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);

47: TYPE plan_abr_info IS RECORD (
48: pl_id ben_cwb_pl_dsgn.pl_id%type,
49: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
50: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
51: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
52:
53: TYPE g_abr_info_t IS TABLE OF plan_abr_info;
54:
55: g_package VARCHAR2 (80) := 'BEN_CWB_BACKOUT_POST_PROCESS';

Line 108: FROM ben_cwb_pl_dsgn

104: ,v_pl_id IN NUMBER
105: ,v_oipl_id IN NUMBER)
106: IS
107: SELECT ws_element_type_id, ws_input_value_id
108: FROM ben_cwb_pl_dsgn
109: WHERE lf_evt_ocrd_dt = v_lf_evt_ocrd_date
110: AND pl_id = v_pl_id
111: AND oipl_id = v_oipl_id;
112:

Line 120: FROM ben_cwb_pl_dsgn dsgn

116: ,v_oipl_id IN NUMBER
117: ,v_lf_evt_ocrd_date IN DATE)
118: IS
119: SELECT ovrid_rt_strt_dt
120: FROM ben_cwb_pl_dsgn dsgn
121: WHERE group_pl_id = v_group_pl_id
122: AND pl_id = v_pl_id
123: AND group_oipl_id = v_group_oipl_id
124: AND oipl_id = v_oipl_id

Line 254: , ben_cwb_pl_dsgn dsgn

250: , ben_cwb_group_hrchy hrchy
251: , per_business_groups_perf bg
252: , ben_cwb_person_info per
253: , ben_cwb_person_rates rates
254: , ben_cwb_pl_dsgn dsgn
255: WHERE pil.per_in_ler_stat_cd = 'PROCD'
256: AND pil.group_pl_id = v_pl_id
257: AND pil.lf_evt_ocrd_dt = v_lf_evt_orcd_date
258: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 362: --, ben_cwb_pl_dsgn dsgn

358: , per_business_groups_perf bg
359: , ben_cwb_person_info per
360: , ben_cwb_person_info mgr_per
361: --, ben_cwb_person_rates rates
362: --, ben_cwb_pl_dsgn dsgn
363: WHERE pil.per_in_ler_stat_cd = 'PROCD'
364: AND pil.group_pl_id = v_pl_id
365: AND pil.lf_evt_ocrd_dt = v_lf_evt_orcd_date
366: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 462: FROM ben_cwb_pl_dsgn dsgn

458: SELECT dsgn.perf_revw_strt_dt
459: , nvl(dsgn.ovr_perf_revw_strt_dt, dsgn.perf_revw_strt_dt)
460: , dsgn.asg_updt_eff_date
461: , dsgn.emp_interview_typ_cd
462: FROM ben_cwb_pl_dsgn dsgn
463: WHERE dsgn.pl_id = v_pl_id
464: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
465: AND dsgn.oipl_id = -1;
466:

Line 482: , ben_cwb_pl_dsgn dsgn

478: CURSOR c_task_type (v_group_per_in_ler_id IN NUMBER)
479: IS
480: SELECT dsgn.ws_sub_acty_typ_cd
481: FROM ben_cwb_person_rates rt
482: , ben_cwb_pl_dsgn dsgn
483: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
484: AND rt.pl_id = dsgn.pl_id
485: AND rt.oipl_id = dsgn.oipl_id
486: AND rt.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt;

Line 590: FROM ben_cwb_pl_dsgn dsgn

586: CURSOR c_group_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
587: IS
588: SELECT dsgn.NAME
589: , dsgn.group_pl_id
590: FROM ben_cwb_pl_dsgn dsgn
591: WHERE dsgn.pl_id = v_group_pl_id
592: AND dsgn.pl_id = dsgn.group_pl_id
593: AND dsgn.group_oipl_id = -1
594: AND dsgn.oipl_id = dsgn.group_oipl_id

Line 601: FROM ben_cwb_pl_dsgn dsgn

597: CURSOR c_group_option_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
598: IS
599: SELECT dsgn.NAME
600: , dsgn.group_oipl_id
601: FROM ben_cwb_pl_dsgn dsgn
602: WHERE dsgn.pl_id = v_group_pl_id
603: AND dsgn.pl_id = dsgn.group_pl_id
604: AND dsgn.oipl_id = dsgn.group_oipl_id
605: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt

Line 612: FROM ben_cwb_pl_dsgn dsgn

608: CURSOR c_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
609: IS
610: SELECT dsgn.NAME
611: , dsgn.pl_id
612: FROM ben_cwb_pl_dsgn dsgn
613: WHERE dsgn.group_pl_id = v_group_pl_id
614: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
615: AND dsgn.oipl_id = -1
616: AND dsgn.pl_id <> dsgn.group_pl_id;

Line 622: FROM ben_cwb_pl_dsgn dsgn

618: CURSOR c_option_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
619: IS
620: SELECT dsgn.NAME
621: , dsgn.oipl_id
622: FROM ben_cwb_pl_dsgn dsgn
623: WHERE dsgn.group_pl_id = v_group_pl_id
624: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
625: AND dsgn.pl_id <> dsgn.group_pl_id
626: AND dsgn.oipl_id <> -1;

Line 683: ben_cwb_pl_dsgn dsgn

679: SELECT trans.transaction_id,
680: trans.attribute1,
681: trans.attribute2
682: FROM ben_transaction trans,
683: ben_cwb_pl_dsgn dsgn
684: WHERE trans.transaction_id IN
685: (SELECT DISTINCT pl_id
686: FROM ben_cwb_person_rates rates
687: WHERE group_per_in_ler_id = v_group_per_in_ler_id)

Line 719: , ben_cwb_pl_dsgn dsgn

715: , rt.currency
716: , rt.comp_posting_date
717: FROM ben_cwb_person_rates rt
718: , ben_oipl_f oipl
719: , ben_cwb_pl_dsgn dsgn
720: , ben_opt_f opt
721: , ben_cwb_person_info info
722: , ben_per_in_ler pil
723: , ben_cwb_xchg xchg

Line 743: AND exists (select null from ben_cwb_pl_dsgn where pl_id = rt.pl_id and oipl_id = -1 and nvl(do_not_process_flag,'N') <> 'Y');

739: AND v_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date
740: and xchg.group_pl_id = rt.group_pl_id
741: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
742: and xchg.currency = rt.currency
743: AND exists (select null from ben_cwb_pl_dsgn where pl_id = rt.pl_id and oipl_id = -1 and nvl(do_not_process_flag,'N') <> 'Y');
744:
745:
746: CURSOR c_non_sal_comp_rates (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
747: IS

Line 780: , ben_cwb_pl_dsgn dsgn

776: , info.fte_factor
777: , rt.currency
778: , rt.comp_posting_date
779: FROM ben_cwb_person_rates rt
780: , ben_cwb_pl_dsgn dsgn
781: , ben_cwb_person_info info
782: , ben_per_in_ler pil
783: , ben_oipl_f oipl
784: , ben_opt_f opt

Line 802: AND exists (select null from ben_cwb_pl_dsgn where pl_id = rt.pl_id and oipl_id = -1 and nvl(do_not_process_flag,'N') <> 'Y');

798: AND v_effective_date BETWEEN oipl.effective_start_date (+)AND oipl.effective_end_date (+)
799: and xchg.group_pl_id = rt.group_pl_id
800: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
801: and xchg.currency = rt.currency
802: AND exists (select null from ben_cwb_pl_dsgn where pl_id = rt.pl_id and oipl_id = -1 and nvl(do_not_process_flag,'N') <> 'Y');
803:
804: CURSOR c_input_value_precision(
805: v_assignment_id NUMBER
806: , v_effective_date DATE

Line 836: FROM ben_cwb_pl_dsgn dsgn,

832: SELECT dsgn.pl_annulization_factor,
833: dsgn.uom_precision,
834: info.pay_annulization_factor,
835: dsgn.salary_change_reason
836: FROM ben_cwb_pl_dsgn dsgn,
837: ben_cwb_person_info info
838: WHERE dsgn.group_pl_id = v_group_pl_id
839: AND dsgn.group_pl_id = dsgn.pl_id
840: AND dsgn.oipl_id = -1

Line 991: FROM ben_cwb_pl_dsgn pl

987: SELECT per.full_name
988: ,per.person_id
989: ,per.group_per_in_ler_id
990: ,pl.name plan_name
991: FROM ben_cwb_pl_dsgn pl
992: ,ben_cwb_person_info per
993: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
994: and per.group_pl_id = pl.pl_id
995: and pl.oipl_id = -1;

Line 2410: ben_cwb_pl_dsgn dsgn

2406: per_saladmin_utility.get_pay_annualization_factor(info.assignment_id,rates.comp_posting_date,null,'PERIOD') pay_annual_ftr,
2407: dsgn.pl_annulization_factor plan_pay_annual_ftr --12714771
2408: from ben_cwb_person_rates rates,
2409: ben_cwb_person_info info,
2410: ben_cwb_pl_dsgn dsgn
2411: where rates.group_per_in_ler_id = p_per_in_ler_id
2412: and rates.pl_id = l_pl_id
2413: and rates.oipl_id = l_oipl_id
2414: and rates.group_per_in_ler_id = info.group_per_in_ler_id

Line 2449: ben_cwb_pl_dsgn pl

2445: cursor c_plan_salary is
2446: select
2447: nvl(plRt.ws_val,0) ws_val
2448: from
2449: ben_cwb_pl_dsgn pl
2450: ,ben_cwb_person_rates plRt
2451: ,ben_cwb_person_info per
2452: where plRt.group_per_in_ler_id = p_per_in_ler_id
2453: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 2466: ben_cwb_pl_dsgn pl

2462: (per.base_salary*per.pay_annulization_factor/pl.pl_annulization_factor) base_salary,
2463: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
2464: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
2465: from
2466: ben_cwb_pl_dsgn pl
2467: ,ben_cwb_person_rates plRt
2468: ,ben_cwb_person_info per
2469: where plRt.group_per_in_ler_id = p_per_in_ler_id
2470: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 2480: ben_cwb_pl_dsgn pl

2476: cursor c_option_salary ( l_oipl_ordr_num number) is
2477: select
2478: nvl(optRt.ws_val,0) ws_val
2479: from
2480: ben_cwb_pl_dsgn pl
2481: ,ben_cwb_person_rates optRt
2482: ,ben_cwb_person_info per
2483: where optRt.group_per_in_ler_id = p_per_in_ler_id
2484: and optRt.group_per_in_ler_id = per.group_per_in_ler_id