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_POST_PROCESS dependencies on BEN_CWB_PL_DSGN

Line 197: plan ben_cwb_pl_dsgn.pl_id%type,

193: --
194: -- Global cursor and variables declaration
195: --
196: TYPE plan_override_date IS RECORD (
197: plan ben_cwb_pl_dsgn.pl_id%type,
198: opt ben_cwb_pl_dsgn.oipl_id%type, --10306828
199: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
200:
201: TYPE g_override_date_t IS TABLE OF plan_override_date;

Line 198: opt ben_cwb_pl_dsgn.oipl_id%type, --10306828

194: -- Global cursor and variables declaration
195: --
196: TYPE plan_override_date IS RECORD (
197: plan ben_cwb_pl_dsgn.pl_id%type,
198: opt ben_cwb_pl_dsgn.oipl_id%type, --10306828
199: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
200:
201: TYPE g_override_date_t IS TABLE OF plan_override_date;
202:

Line 199: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);

195: --
196: TYPE plan_override_date IS RECORD (
197: plan ben_cwb_pl_dsgn.pl_id%type,
198: opt ben_cwb_pl_dsgn.oipl_id%type, --10306828
199: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
200:
201: TYPE g_override_date_t IS TABLE OF plan_override_date;
202:
203: TYPE plan_abr_info IS RECORD (

Line 204: pl_id ben_cwb_pl_dsgn.pl_id%type,

200:
201: TYPE g_override_date_t IS TABLE OF plan_override_date;
202:
203: TYPE plan_abr_info IS RECORD (
204: pl_id ben_cwb_pl_dsgn.pl_id%type,
205: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
206: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
207: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
208:

Line 205: oipl_id ben_cwb_pl_dsgn.oipl_id%type,

201: TYPE g_override_date_t IS TABLE OF plan_override_date;
202:
203: TYPE plan_abr_info IS RECORD (
204: pl_id ben_cwb_pl_dsgn.pl_id%type,
205: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
206: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
207: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
208:
209: TYPE g_abr_info_t IS TABLE OF plan_abr_info;

Line 206: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,

202:
203: TYPE plan_abr_info IS RECORD (
204: pl_id ben_cwb_pl_dsgn.pl_id%type,
205: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
206: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
207: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
208:
209: TYPE g_abr_info_t IS TABLE OF plan_abr_info;
210:

Line 207: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);

203: TYPE plan_abr_info IS RECORD (
204: pl_id ben_cwb_pl_dsgn.pl_id%type,
205: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
206: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
207: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
208:
209: TYPE g_abr_info_t IS TABLE OF plan_abr_info;
210:
211: g_package VARCHAR2 (80) := 'BEN_CWB_POST_PROCESS';

Line 264: FROM ben_cwb_pl_dsgn

260: ,v_pl_id IN NUMBER
261: ,v_oipl_id IN NUMBER)
262: IS
263: SELECT ws_element_type_id, ws_input_value_id
264: FROM ben_cwb_pl_dsgn
265: WHERE lf_evt_ocrd_dt = v_lf_evt_ocrd_date
266: AND pl_id = v_pl_id
267: AND oipl_id = v_oipl_id;
268:

Line 276: FROM ben_cwb_pl_dsgn dsgn

272: ,v_oipl_id IN NUMBER
273: ,v_lf_evt_ocrd_date IN DATE)
274: IS
275: SELECT ovrid_rt_strt_dt
276: FROM ben_cwb_pl_dsgn dsgn
277: WHERE group_pl_id = v_group_pl_id
278: AND pl_id = v_pl_id
279: AND group_oipl_id = v_group_oipl_id
280: AND oipl_id = v_oipl_id

Line 516: , ben_cwb_pl_dsgn dsgn

512: , ben_cwb_group_hrchy hrchy
513: , per_business_groups_perf bg
514: , ben_cwb_person_info per
515: , ben_cwb_person_rates rates
516: , ben_cwb_pl_dsgn dsgn
517: WHERE pil.per_in_ler_stat_cd = 'STRTD'
518: AND pil.group_pl_id = v_pl_id
519: AND pil.lf_evt_ocrd_dt = v_lf_evt_orcd_date
520: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 625: FROM ben_cwb_pl_dsgn dsgn

621: SELECT dsgn.perf_revw_strt_dt
622: , nvl(dsgn.ovr_perf_revw_strt_dt, dsgn.perf_revw_strt_dt)
623: , dsgn.asg_updt_eff_date
624: , dsgn.emp_interview_typ_cd
625: FROM ben_cwb_pl_dsgn dsgn
626: WHERE dsgn.pl_id = v_pl_id
627: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
628: AND dsgn.oipl_id = -1;
629:

Line 645: , ben_cwb_pl_dsgn dsgn

641: CURSOR c_task_type (v_group_per_in_ler_id IN NUMBER)
642: IS
643: SELECT dsgn.ws_sub_acty_typ_cd
644: FROM ben_cwb_person_rates rt
645: , ben_cwb_pl_dsgn dsgn
646: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
647: AND rt.pl_id = dsgn.pl_id
648: AND rt.oipl_id = dsgn.oipl_id
649: AND rt.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt;

Line 707: , ben_cwb_pl_dsgn dsgn

703: min(WS_RT_START_DATE),
704: min(OVRID_RT_STRT_DT)) effective_date
705: FROM ben_cwb_person_rates rt
706: , ben_oipl_f oipl
707: , ben_cwb_pl_dsgn dsgn
708: , ben_opt_f opt
709: , ben_cwb_person_info info
710: , ben_per_in_ler pil
711: , ben_cwb_xchg xchg

Line 726: 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');

722: AND OVRID_RT_STRT_DT BETWEEN oipl.effective_start_date AND oipl.effective_end_date
723: and xchg.group_pl_id = rt.group_pl_id
724: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
725: and xchg.currency = rt.currency
726: 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');
727:
728: CURSOR c_sal_comp_rates (
729: v_group_per_in_ler_id IN NUMBER
730: , v_group_pl_id IN NUMBER

Line 755: , ben_cwb_pl_dsgn dsgn

751: , rt.elig_flag
752: , rt.currency
753: FROM ben_cwb_person_rates rt
754: , ben_oipl_f oipl
755: , ben_cwb_pl_dsgn dsgn
756: , ben_opt_f opt
757: , ben_cwb_person_info info
758: , ben_per_in_ler pil
759: , ben_cwb_xchg xchg

Line 779: 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');

775: AND v_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date
776: and xchg.group_pl_id = rt.group_pl_id
777: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
778: and xchg.currency = rt.currency
779: 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');
780:
781:
782: CURSOR c_non_sal_comp_rates (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
783: IS

Line 814: , ben_cwb_pl_dsgn dsgn

810: , rt.elig_flag
811: , info.fte_factor
812: , rt.currency
813: FROM ben_cwb_person_rates rt
814: , ben_cwb_pl_dsgn dsgn
815: , ben_cwb_person_info info
816: , ben_per_in_ler pil
817: , ben_oipl_f oipl
818: , ben_opt_f opt

Line 834: 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');

830: AND v_effective_date BETWEEN oipl.effective_start_date (+)AND oipl.effective_end_date (+)
831: and xchg.group_pl_id = rt.group_pl_id
832: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
833: and xchg.currency = rt.currency
834: 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');
835:
836: CURSOR c_ranking_info (v_group_per_in_ler_id IN NUMBER)
837: IS
838: SELECT xtra_info.aei_information1

Line 943: FROM ben_cwb_pl_dsgn dsgn

939: CURSOR c_group_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
940: IS
941: SELECT dsgn.NAME
942: , dsgn.group_pl_id
943: FROM ben_cwb_pl_dsgn dsgn
944: WHERE dsgn.pl_id = v_group_pl_id
945: AND dsgn.pl_id = dsgn.group_pl_id
946: AND dsgn.group_oipl_id = -1
947: AND dsgn.oipl_id = dsgn.group_oipl_id

Line 954: FROM ben_cwb_pl_dsgn dsgn

950: CURSOR c_group_option_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
951: IS
952: SELECT dsgn.NAME
953: , dsgn.group_oipl_id
954: FROM ben_cwb_pl_dsgn dsgn
955: WHERE dsgn.pl_id = v_group_pl_id
956: AND dsgn.pl_id = dsgn.group_pl_id
957: AND dsgn.oipl_id = dsgn.group_oipl_id
958: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt

Line 965: FROM ben_cwb_pl_dsgn dsgn

961: CURSOR c_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
962: IS
963: SELECT dsgn.NAME
964: , dsgn.pl_id
965: FROM ben_cwb_pl_dsgn dsgn
966: WHERE dsgn.group_pl_id = v_group_pl_id
967: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
968: AND dsgn.oipl_id = -1
969: AND dsgn.pl_id <> dsgn.group_pl_id;

Line 975: FROM ben_cwb_pl_dsgn dsgn

971: CURSOR c_option_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
972: IS
973: SELECT dsgn.NAME
974: , dsgn.oipl_id
975: FROM ben_cwb_pl_dsgn dsgn
976: WHERE dsgn.group_pl_id = v_group_pl_id
977: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
978: AND dsgn.pl_id <> dsgn.group_pl_id
979: AND dsgn.oipl_id <> -1;

Line 1053: FROM ben_cwb_pl_dsgn dsgn,

1049: SELECT dsgn.pl_annulization_factor,
1050: dsgn.uom_precision,
1051: info.pay_annulization_factor,
1052: dsgn.salary_change_reason
1053: FROM ben_cwb_pl_dsgn dsgn,
1054: ben_cwb_person_info info
1055: WHERE dsgn.group_pl_id = v_group_pl_id
1056: AND dsgn.group_pl_id = dsgn.pl_id
1057: AND dsgn.oipl_id = -1

Line 1203: ben_cwb_pl_dsgn dsgn

1199: SELECT trans.transaction_id,
1200: trans.attribute1,
1201: trans.attribute2
1202: FROM ben_transaction trans,
1203: ben_cwb_pl_dsgn dsgn
1204: WHERE trans.transaction_id IN
1205: (SELECT DISTINCT pl_id
1206: FROM ben_cwb_person_rates rates
1207: WHERE group_per_in_ler_id = v_group_per_in_ler_id)

Line 3379: from ben_cwb_pl_dsgn

3375: IS
3376: --ER:8369634
3377: cursor c_post_zero_salary_increase is
3378: select post_zero_salary_increase
3379: from ben_cwb_pl_dsgn
3380: where pl_id = p_group_pl_id
3381: and lf_evt_ocrd_dt = p_lf_evt_ocrd_date
3382: and group_oipl_id = -1;
3383: