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_WS_IMPORT_PKG dependencies on BEN_CWB_PERSON_RATES

Line 164: From BEN_CWB_PERSON_RATES PlRt

160: PlRt.LF_EVT_OCRD_DT LF_EVT_OCRD_DT,
161: PlRt.Object_Version_Number OVN,
162: PlRt.ws_val ws_val,
163: plrt.ws_rt_start_date WS_RT_START_DATE
164: From BEN_CWB_PERSON_RATES PlRt
165: ,ben_cwb_pl_dsgn dsgn
166: Where PlRt.PERSON_RATE_ID = P_PERSON_RATE_ID
167: And PlRt.ELIG_FLAG='Y'
168: and plRt.pl_id = dsgn.pl_id

Line 222: BEN_CWB_PERSON_RATES_API.update_person_rate

218: l_ws_rt_start_date := l_upd_rec.ws_rt_start_date;
219: ELSE
220: l_ws_rt_start_date := p_ws_rt_start_date;
221: END IF;
222: BEN_CWB_PERSON_RATES_API.update_person_rate
223: ( p_group_per_in_ler_id => l_upd_rec.GROUP_PER_IN_LER_ID
224: ,p_pl_id => l_upd_rec.PL_ID
225: ,p_oipl_id => l_upd_rec.OIPL_ID
226: ,p_group_pl_id => l_upd_rec.GROUP_PL_ID

Line 262: from ben_cwb_person_rates

258: Cursor csr_person_rate_info (l_person_rate_id IN Number)
259: IS
260: Select group_pl_id
261: ,lf_evt_ocrd_dt
262: from ben_cwb_person_rates
263: where person_rate_id = l_person_rate_id;
264:
265: Cursor csr_person_tasks_info(l_group_pl_id In Number, l_lf_evt_ocrd_dt Date)
266: IS

Line 344: from ben_cwb_person_rates

340: IS
341: Cursor csr_group_per_in_ler_id (l_person_rate_id IN Number)
342: IS
343: Select group_per_in_ler_id
344: from ben_cwb_person_rates
345: where person_rate_id = l_person_rate_id;
346:
347: l_proc Varchar2(72) := g_package||'get_group_per_in_ler_id';
348: l_rate_id Number;

Line 907: From BEN_CWB_PERSON_RATES PlRt

903: ,dsgn.misc3_rndg_cd m3_rndg_cd
904: ,dsgn.tot_comp_rndg_cd tc_rndg_cd
905: ,dsgn.oth_comp_rndg_cd oc_rndg_cd
906: ,dsgn.stat_sal_rndg_cd ss_rndg_cd
907: From BEN_CWB_PERSON_RATES PlRt
908: ,ben_cwb_pl_dsgn dsgn
909: Where PlRt.PERSON_RATE_ID = P_PERSON_RATE_ID
910: And PlRt.ELIG_FLAG='Y'
911: and plRt.pl_id = dsgn.pl_id

Line 971: BEN_CWB_PERSON_RATES_API.update_person_rate

967: end loop;
968: if g_debug then
969: hr_utility.set_location(l_proc,30);
970: end if;
971: BEN_CWB_PERSON_RATES_API.update_person_rate
972: ( p_group_per_in_ler_id => l_upd_rec.GROUP_PER_IN_LER_ID
973: ,p_pl_id => l_upd_rec.PL_ID
974: ,p_oipl_id => l_upd_rec.OIPL_ID
975: ,p_group_pl_id => l_upd_rec.GROUP_PL_ID

Line 1008: from ben_cwb_person_rates

1004: Cursor csr_group_pl_id (l_person_rate_id IN Number)
1005: IS
1006: Select group_pl_id,
1007: lf_evt_ocrd_dt
1008: from ben_cwb_person_rates
1009: where person_rate_id = l_person_rate_id;
1010:
1011:
1012: l_rate_id Number;

Line 1042: FROM BEN_CWB_PERSON_RATES PlRt

1038: function get_plan_person_rate_id(p_opt_person_rate_id in number)
1039: return number is
1040: CURSOR c_get_pl_per_rates IS
1041: SELECT PlRt.person_rate_id
1042: FROM BEN_CWB_PERSON_RATES PlRt
1043: ,ben_cwb_person_rates optRt
1044: WHERE optRt.PERSON_RATE_ID = p_opt_person_rate_id
1045: and optRt.group_per_in_ler_id = plRt.group_per_in_ler_id
1046: and optRt.pl_id = plRt.pl_id

Line 1043: ,ben_cwb_person_rates optRt

1039: return number is
1040: CURSOR c_get_pl_per_rates IS
1041: SELECT PlRt.person_rate_id
1042: FROM BEN_CWB_PERSON_RATES PlRt
1043: ,ben_cwb_person_rates optRt
1044: WHERE optRt.PERSON_RATE_ID = p_opt_person_rate_id
1045: and optRt.group_per_in_ler_id = plRt.group_per_in_ler_id
1046: and optRt.pl_id = plRt.pl_id
1047: and plRt.oipl_id = -1;

Line 1284: FROM BEN_CWB_PERSON_RATES PlRt

1280:
1281: CURSOR Csr_get_pl_ws_val(l_PL_PERSON_RATE_ID IN NUMBER)
1282: IS
1283: SELECT PlRt.WS_VAL
1284: FROM BEN_CWB_PERSON_RATES PlRt
1285: WHERE PlRt.PERSON_RATE_ID = l_PL_PERSON_RATE_ID;
1286:
1287: CURSOR csr_cpi_flex_info(l_group_per_in_ler_id IN NUMBER)
1288: IS

Line 1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;

1371:
1372: l_interfac_code bne_interface_cols_b.interface_code%TYPE;
1373: l_base_layout_code bne_layout_cols.layout_code%TYPE;
1374: l_is_read_only csr_is_read_only%RowType;
1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;

Line 1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;

1372: l_interfac_code bne_interface_cols_b.interface_code%TYPE;
1373: l_base_layout_code bne_layout_cols.layout_code%TYPE;
1374: l_is_read_only csr_is_read_only%RowType;
1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
1377: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
1378: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
1379: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
1380: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;