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 187: plan ben_cwb_pl_dsgn.pl_id%type,

183: --
184: -- Global cursor and variables declaration
185: --
186: TYPE plan_override_date IS RECORD (
187: plan ben_cwb_pl_dsgn.pl_id%type,
188: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
189:
190: TYPE g_override_date_t IS TABLE OF plan_override_date;
191:

Line 188: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);

184: -- Global cursor and variables declaration
185: --
186: TYPE plan_override_date IS RECORD (
187: plan ben_cwb_pl_dsgn.pl_id%type,
188: date ben_cwb_pl_dsgn.ovrid_rt_strt_dt%type);
189:
190: TYPE g_override_date_t IS TABLE OF plan_override_date;
191:
192: TYPE plan_abr_info IS RECORD (

Line 193: pl_id ben_cwb_pl_dsgn.pl_id%type,

189:
190: TYPE g_override_date_t IS TABLE OF plan_override_date;
191:
192: TYPE plan_abr_info IS RECORD (
193: pl_id ben_cwb_pl_dsgn.pl_id%type,
194: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
195: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
196: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
197:

Line 194: oipl_id ben_cwb_pl_dsgn.oipl_id%type,

190: TYPE g_override_date_t IS TABLE OF plan_override_date;
191:
192: TYPE plan_abr_info IS RECORD (
193: pl_id ben_cwb_pl_dsgn.pl_id%type,
194: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
195: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
196: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
197:
198: TYPE g_abr_info_t IS TABLE OF plan_abr_info;

Line 195: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,

191:
192: TYPE plan_abr_info IS RECORD (
193: pl_id ben_cwb_pl_dsgn.pl_id%type,
194: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
195: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
196: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
197:
198: TYPE g_abr_info_t IS TABLE OF plan_abr_info;
199:

Line 196: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);

192: TYPE plan_abr_info IS RECORD (
193: pl_id ben_cwb_pl_dsgn.pl_id%type,
194: oipl_id ben_cwb_pl_dsgn.oipl_id%type,
195: element_type_id ben_cwb_pl_dsgn.ws_element_type_id%type,
196: input_value_id ben_cwb_pl_dsgn.ws_input_value_id%type);
197:
198: TYPE g_abr_info_t IS TABLE OF plan_abr_info;
199:
200: g_package VARCHAR2 (80) := 'BEN_CWB_POST_PROCESS';

Line 253: FROM ben_cwb_pl_dsgn

249: ,v_pl_id IN NUMBER
250: ,v_oipl_id IN NUMBER)
251: IS
252: SELECT ws_element_type_id, ws_input_value_id
253: FROM ben_cwb_pl_dsgn
254: WHERE lf_evt_ocrd_dt = v_lf_evt_ocrd_date
255: AND pl_id = v_pl_id
256: AND oipl_id = v_oipl_id;
257:

Line 265: FROM ben_cwb_pl_dsgn dsgn

261: ,v_oipl_id IN NUMBER
262: ,v_lf_evt_ocrd_date IN DATE)
263: IS
264: SELECT ovrid_rt_strt_dt
265: FROM ben_cwb_pl_dsgn dsgn
266: WHERE group_pl_id = v_group_pl_id
267: AND pl_id = v_pl_id
268: AND group_oipl_id = v_group_oipl_id
269: AND oipl_id = v_oipl_id

Line 505: , ben_cwb_pl_dsgn dsgn

501: , ben_cwb_group_hrchy hrchy
502: , per_business_groups_perf bg
503: , ben_cwb_person_info per
504: , ben_cwb_person_rates rates
505: , ben_cwb_pl_dsgn dsgn
506: WHERE pil.per_in_ler_stat_cd = 'STRTD'
507: AND pil.group_pl_id = v_pl_id
508: AND pil.lf_evt_ocrd_dt = v_lf_evt_orcd_date
509: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 614: FROM ben_cwb_pl_dsgn dsgn

610: SELECT dsgn.perf_revw_strt_dt
611: , nvl(dsgn.ovr_perf_revw_strt_dt, dsgn.perf_revw_strt_dt)
612: , dsgn.asg_updt_eff_date
613: , dsgn.emp_interview_typ_cd
614: FROM ben_cwb_pl_dsgn dsgn
615: WHERE dsgn.pl_id = v_pl_id
616: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
617: AND dsgn.oipl_id = -1;
618:

Line 634: , ben_cwb_pl_dsgn dsgn

630: CURSOR c_task_type (v_group_per_in_ler_id IN NUMBER)
631: IS
632: SELECT dsgn.ws_sub_acty_typ_cd
633: FROM ben_cwb_person_rates rt
634: , ben_cwb_pl_dsgn dsgn
635: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
636: AND rt.pl_id = dsgn.pl_id
637: AND rt.oipl_id = dsgn.oipl_id
638: AND rt.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt;

Line 695: , ben_cwb_pl_dsgn dsgn

691: min(WS_RT_START_DATE),
692: min(OVRID_RT_STRT_DT)) effective_date
693: FROM ben_cwb_person_rates rt
694: , ben_oipl_f oipl
695: , ben_cwb_pl_dsgn dsgn
696: , ben_opt_f opt
697: , ben_cwb_person_info info
698: , ben_per_in_ler pil
699: , ben_cwb_xchg xchg

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

710: AND OVRID_RT_STRT_DT BETWEEN oipl.effective_start_date AND oipl.effective_end_date
711: and xchg.group_pl_id = rt.group_pl_id
712: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
713: and xchg.currency = rt.currency
714: 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');
715:
716: CURSOR c_sal_comp_rates (
717: v_group_per_in_ler_id IN NUMBER
718: , v_group_pl_id IN NUMBER

Line 743: , ben_cwb_pl_dsgn dsgn

739: , rt.elig_flag
740: , rt.currency
741: FROM ben_cwb_person_rates rt
742: , ben_oipl_f oipl
743: , ben_cwb_pl_dsgn dsgn
744: , ben_opt_f opt
745: , ben_cwb_person_info info
746: , ben_per_in_ler pil
747: , ben_cwb_xchg xchg

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

763: AND v_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date
764: and xchg.group_pl_id = rt.group_pl_id
765: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
766: and xchg.currency = rt.currency
767: 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');
768:
769:
770: CURSOR c_non_sal_comp_rates (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
771: IS

Line 802: , ben_cwb_pl_dsgn dsgn

798: , rt.elig_flag
799: , info.fte_factor
800: , rt.currency
801: FROM ben_cwb_person_rates rt
802: , ben_cwb_pl_dsgn dsgn
803: , ben_cwb_person_info info
804: , ben_per_in_ler pil
805: , ben_oipl_f oipl
806: , ben_opt_f opt

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

818: AND v_effective_date BETWEEN oipl.effective_start_date (+)AND oipl.effective_end_date (+)
819: and xchg.group_pl_id = rt.group_pl_id
820: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt
821: and xchg.currency = rt.currency
822: 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');
823:
824: CURSOR c_ranking_info (v_group_per_in_ler_id IN NUMBER)
825: IS
826: SELECT xtra_info.aei_information1

Line 930: FROM ben_cwb_pl_dsgn dsgn

926: CURSOR c_group_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
927: IS
928: SELECT dsgn.NAME
929: , dsgn.group_pl_id
930: FROM ben_cwb_pl_dsgn dsgn
931: WHERE dsgn.pl_id = v_group_pl_id
932: AND dsgn.pl_id = dsgn.group_pl_id
933: AND dsgn.group_oipl_id = -1
934: AND dsgn.oipl_id = dsgn.group_oipl_id

Line 941: FROM ben_cwb_pl_dsgn dsgn

937: CURSOR c_group_option_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
938: IS
939: SELECT dsgn.NAME
940: , dsgn.group_oipl_id
941: FROM ben_cwb_pl_dsgn dsgn
942: WHERE dsgn.pl_id = v_group_pl_id
943: AND dsgn.pl_id = dsgn.group_pl_id
944: AND dsgn.oipl_id = dsgn.group_oipl_id
945: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt

Line 952: FROM ben_cwb_pl_dsgn dsgn

948: CURSOR c_plan_name (v_group_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)
949: IS
950: SELECT dsgn.NAME
951: , dsgn.pl_id
952: FROM ben_cwb_pl_dsgn dsgn
953: WHERE dsgn.group_pl_id = v_group_pl_id
954: AND dsgn.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
955: AND dsgn.oipl_id = -1
956: AND dsgn.pl_id <> dsgn.group_pl_id;

Line 962: FROM ben_cwb_pl_dsgn dsgn

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

Line 1040: FROM ben_cwb_pl_dsgn dsgn,

1036: SELECT dsgn.pl_annulization_factor,
1037: dsgn.uom_precision,
1038: info.pay_annulization_factor,
1039: dsgn.salary_change_reason
1040: FROM ben_cwb_pl_dsgn dsgn,
1041: ben_cwb_person_info info
1042: WHERE dsgn.group_pl_id = v_group_pl_id
1043: AND dsgn.group_pl_id = dsgn.pl_id
1044: AND dsgn.oipl_id = -1

Line 1190: ben_cwb_pl_dsgn dsgn

1186: SELECT trans.transaction_id,
1187: trans.attribute1,
1188: trans.attribute2
1189: FROM ben_transaction trans,
1190: ben_cwb_pl_dsgn dsgn
1191: WHERE trans.transaction_id IN
1192: (SELECT DISTINCT pl_id
1193: FROM ben_cwb_person_rates rates
1194: WHERE group_per_in_ler_id = v_group_per_in_ler_id)