APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PERSON_RATES

Line 163: From BEN_CWB_PERSON_RATES PlRt

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

Line 221: BEN_CWB_PERSON_RATES_API.update_person_rate

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

Line 261: from ben_cwb_person_rates

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

Line 343: from ben_cwb_person_rates

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

Line 552: from ben_cwb_person_rates

548: Cursor csr_group_pl_id (l_person_rate_id IN Number)
549: IS
550: Select group_pl_id,
551: lf_evt_ocrd_dt
552: from ben_cwb_person_rates
553: where person_rate_id = l_person_rate_id;
554:
555:
556: l_rate_id Number;

Line 586: FROM BEN_CWB_PERSON_RATES PlRt

582: function get_plan_person_rate_id(p_opt_person_rate_id in number)
583: return number is
584: CURSOR c_get_pl_per_rates IS
585: SELECT PlRt.person_rate_id
586: FROM BEN_CWB_PERSON_RATES PlRt
587: ,ben_cwb_person_rates optRt
588: WHERE optRt.PERSON_RATE_ID = p_opt_person_rate_id
589: and optRt.group_per_in_ler_id = plRt.group_per_in_ler_id
590: and optRt.pl_id = plRt.pl_id

Line 587: ,ben_cwb_person_rates optRt

583: return number is
584: CURSOR c_get_pl_per_rates IS
585: SELECT PlRt.person_rate_id
586: FROM BEN_CWB_PERSON_RATES PlRt
587: ,ben_cwb_person_rates optRt
588: WHERE optRt.PERSON_RATE_ID = p_opt_person_rate_id
589: and optRt.group_per_in_ler_id = plRt.group_per_in_ler_id
590: and optRt.pl_id = plRt.pl_id
591: and plRt.oipl_id = -1;

Line 825: FROM BEN_CWB_PERSON_RATES PlRt

821:
822: CURSOR Csr_get_pl_ws_val(l_PL_PERSON_RATE_ID IN NUMBER)
823: IS
824: SELECT PlRt.WS_VAL
825: FROM BEN_CWB_PERSON_RATES PlRt
826: WHERE PlRt.PERSON_RATE_ID = l_PL_PERSON_RATE_ID;
827:
828: CURSOR csr_cpi_flex_info(l_group_per_in_ler_id IN NUMBER)
829: IS

Line 904: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;

900: and intf.sequence_num = lay.interface_seq_num
901: and ((intf.sequence_num between 200 and 234) or (intf.sequence_num between 136 and 150));
902:
903: l_is_read_only csr_is_read_only%RowType;
904: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;

Line 905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;

901: and ((intf.sequence_num between 200 and 234) or (intf.sequence_num between 136 and 150));
902:
903: l_is_read_only csr_is_read_only%RowType;
904: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
905: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
906: l_cpi_attribute_category BEN_CWB_PERSON_INFO.cpi_attribute_category%TYPE;
907: l_cpi_attribute1 BEN_CWB_PERSON_INFO.cpi_attribute1%TYPE;
908: l_cpi_attribute2 BEN_CWB_PERSON_INFO.cpi_attribute2%TYPE;
909: l_cpi_attribute3 BEN_CWB_PERSON_INFO.cpi_attribute3%TYPE;