APPS.BEN_CWB_UTILS dependencies on BEN_CWB_PERSON_RATES

Line 992: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

988: p_ws_sub_acty_typ_cd in varchar2)
989: Is
990: cursor cur_option1_rate is
991: Select bcpr.*
992: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
993: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
994: And bcpd.group_pl_id = p_group_plan_id
995: -- AND bcpd.pl_id = p_group_plan_id
996: And bcpd.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1045: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1041: Is
1042: --- ws_nmmntry_uom need to be decode from lookup table
1043: Cursor cur_option1_units is
1044: Select decode(ws_nnmntry_uom,null,currency, hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom) )
1045: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1046: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1047: And bcpd.group_pl_id = p_group_plan_id
1048: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1049: And bcpr.pl_id = bcpd.pl_id

Line 1290: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1286: p_ws_sub_acty_typ_cd in varchar2)
1287: Is
1288: cursor cur_option2_rate is
1289: Select bcpr.*
1290: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1291: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1292: And bcpd.group_pl_id = p_group_plan_id
1293: --AND bcpd.pl_id = p_group_plan_id
1294: And bcpd.lf_evt_ocrd_dt= p_lf_evt_ocrd_dt

Line 1343: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1339: Is
1340: ----- ws_nnmntry_uom needs to be decoded from lookup table
1341: Cursor cur_option2_units is
1342: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1343: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1344: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1345: And bcpd.group_pl_id = p_group_plan_id
1346: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1347: And bcpr.pl_id = bcpd.pl_id

Line 1589: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1585: p_ws_sub_acty_typ_cd in varchar2)
1586: Is
1587: cursor cur_option3_rate is
1588: Select bcpr.*
1589: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1590: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1591: And bcpd.group_pl_id = p_group_plan_id
1592: -- AND bcpd.pl_id = p_group_plan_id
1593: And bcpd.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1642: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1638: Is
1639: -- ws_nnmntry_uom needs to be decoded from lookup table
1640: Cursor cur_option3_units is
1641: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1642: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1643: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1644: And bcpd.group_pl_id = p_group_plan_id
1645: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1646: And bcpr.pl_id = bcpd.pl_id

Line 1886: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1882: p_ws_sub_acty_typ_cd in varchar2)
1883: Is
1884: cursor cur_option4_rate is
1885: Select bcpr.*
1886: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1887: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1888: And bcpd.group_pl_id = p_group_plan_id
1889: -- AND bcpd.pl_id = p_group_plan_id
1890: And bcpd.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1938: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1934: Is
1935: -- ws_nnmntry_uom needs to be decoded from lookup table
1936: Cursor cur_option4_units is
1937: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1938: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1939: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1940: And bcpd.group_pl_id = p_group_plan_id
1941: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1942: And bcpr.pl_id = bcpd.pl_id

Line 2161: from ben_cwb_person_rates

2157: -- always gets a new group_per_in_ler_id for each cycle. So for
2158: -- one group_per_in_ler_id, we can find only one lf_evt_ocrd_dt
2159: cursor c_prior_person_rate_dt is
2160: select max(lf_evt_ocrd_dt)
2161: from ben_cwb_person_rates
2162: where group_per_in_ler_id = p_group_per_in_ler_id
2163: and group_pl_id = p_group_plan_id
2164: --and pl_id = p_pl_id
2165: and lf_evt_ocrd_dt < p_lf_evt_ocrd_dt

Line 2170: select * from ben_cwb_person_rates

2166: and elig_flag = 'Y';
2167:
2168: -- *** change here. commented out group_pl_id and using pl_id
2169: cursor c_person_rates (c_lf_evt_ocrd_dt Date) is
2170: select * from ben_cwb_person_rates
2171: where group_per_in_ler_id = p_group_per_in_ler_id
2172: and group_pl_id = p_group_plan_id
2173: --and pl_id = p_pl_id
2174: and oipl_id = p_oipl_id

Line 2221: from per_pay_proposals ppp ,ben_cwb_person_rates rts

2217: l_proposed_salary number := 0;
2218:
2219: cursor c_pay_proposal is
2220: select max(nvl(proposed_salary_n,0))
2221: from per_pay_proposals ppp ,ben_cwb_person_rates rts
2222: where rts.pay_proposal_id = ppp.pay_proposal_id
2223: and rts.group_per_in_ler_id = p_group_per_in_ler_id
2224: and rts.group_pl_id = p_group_plan_id
2225: and rts.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt

Line 2335: ,ben_cwb_person_rates rts

2331: -- return the comp_posting_date
2332: cursor c_pay_proposal_date is
2333: select max(change_date)
2334: from per_pay_proposals ppp
2335: ,ben_cwb_person_rates rts
2336: where rts.pay_proposal_id = ppp.pay_proposal_id
2337: and rts.group_per_in_ler_id = p_group_per_in_ler_id
2338: and rts.group_pl_id = p_group_plan_id
2339: and rts.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt

Line 2820: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

2816: Is
2817:
2818: Cursor cur_option_currency is
2819: Select currency
2820: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
2821: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
2822: And bcpd.group_pl_id = p_group_plan_id
2823: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
2824: And bcpr.pl_id = bcpd.pl_id