APPS.BEN_CWB_UTILS dependencies on BEN_CWB_PERSON_RATES

Line 485: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

481: p_ws_sub_acty_typ_cd in varchar2)
482: Is
483: cursor cur_option1_rate is
484: Select bcpr.*
485: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
486: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
487: And bcpd.group_pl_id = p_group_plan_id
488: -- AND bcpd.pl_id = p_group_plan_id
489: And bcpd.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 538: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

534: Is
535: --- ws_nmmntry_uom need to be decode from lookup table
536: Cursor cur_option1_units is
537: Select decode(ws_nnmntry_uom,null,currency, hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom) )
538: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
539: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
540: And bcpd.group_pl_id = p_group_plan_id
541: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
542: And bcpr.pl_id = bcpd.pl_id

Line 783: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

779: p_ws_sub_acty_typ_cd in varchar2)
780: Is
781: cursor cur_option2_rate is
782: Select bcpr.*
783: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
784: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
785: And bcpd.group_pl_id = p_group_plan_id
786: --AND bcpd.pl_id = p_group_plan_id
787: And bcpd.lf_evt_ocrd_dt= p_lf_evt_ocrd_dt

Line 836: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

832: Is
833: ----- ws_nnmntry_uom needs to be decoded from lookup table
834: Cursor cur_option2_units is
835: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
836: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
837: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
838: And bcpd.group_pl_id = p_group_plan_id
839: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
840: And bcpr.pl_id = bcpd.pl_id

Line 1082: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1078: p_ws_sub_acty_typ_cd in varchar2)
1079: Is
1080: cursor cur_option3_rate is
1081: Select bcpr.*
1082: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1083: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1084: And bcpd.group_pl_id = p_group_plan_id
1085: -- AND bcpd.pl_id = p_group_plan_id
1086: And bcpd.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1135: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1131: Is
1132: -- ws_nnmntry_uom needs to be decoded from lookup table
1133: Cursor cur_option3_units is
1134: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1135: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1136: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1137: And bcpd.group_pl_id = p_group_plan_id
1138: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1139: And bcpr.pl_id = bcpd.pl_id

Line 1379: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1375: p_ws_sub_acty_typ_cd in varchar2)
1376: Is
1377: cursor cur_option4_rate is
1378: Select bcpr.*
1379: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1380: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1381: And bcpd.group_pl_id = p_group_plan_id
1382: -- AND bcpd.pl_id = p_group_plan_id
1383: And bcpd.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1431: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

1427: Is
1428: -- ws_nnmntry_uom needs to be decoded from lookup table
1429: Cursor cur_option4_units is
1430: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1431: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1432: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1433: And bcpd.group_pl_id = p_group_plan_id
1434: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1435: And bcpr.pl_id = bcpd.pl_id

Line 1654: from ben_cwb_person_rates

1650: -- always gets a new group_per_in_ler_id for each cycle. So for
1651: -- one group_per_in_ler_id, we can find only one lf_evt_ocrd_dt
1652: cursor c_prior_person_rate_dt is
1653: select max(lf_evt_ocrd_dt)
1654: from ben_cwb_person_rates
1655: where group_per_in_ler_id = p_group_per_in_ler_id
1656: and group_pl_id = p_group_plan_id
1657: --and pl_id = p_pl_id
1658: and lf_evt_ocrd_dt < p_lf_evt_ocrd_dt

Line 1663: select * from ben_cwb_person_rates

1659: and elig_flag = 'Y';
1660:
1661: -- *** change here. commented out group_pl_id and using pl_id
1662: cursor c_person_rates (c_lf_evt_ocrd_dt Date) is
1663: select * from ben_cwb_person_rates
1664: where group_per_in_ler_id = p_group_per_in_ler_id
1665: and group_pl_id = p_group_plan_id
1666: --and pl_id = p_pl_id
1667: and oipl_id = p_oipl_id

Line 1714: from per_pay_proposals ppp ,ben_cwb_person_rates rts

1710: l_proposed_salary number := 0;
1711:
1712: cursor c_pay_proposal is
1713: select max(nvl(proposed_salary_n,0))
1714: from per_pay_proposals ppp ,ben_cwb_person_rates rts
1715: where rts.pay_proposal_id = ppp.pay_proposal_id
1716: and rts.group_per_in_ler_id = p_group_per_in_ler_id
1717: and rts.group_pl_id = p_group_plan_id
1718: and rts.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt

Line 1828: ,ben_cwb_person_rates rts

1824: -- return the comp_posting_date
1825: cursor c_pay_proposal_date is
1826: select max(change_date)
1827: from per_pay_proposals ppp
1828: ,ben_cwb_person_rates rts
1829: where rts.pay_proposal_id = ppp.pay_proposal_id
1830: and rts.group_per_in_ler_id = p_group_per_in_ler_id
1831: and rts.group_pl_id = p_group_plan_id
1832: and rts.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt

Line 2313: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd

2309: Is
2310:
2311: Cursor cur_option_currency is
2312: Select currency
2313: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
2314: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
2315: And bcpd.group_pl_id = p_group_plan_id
2316: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
2317: And bcpr.pl_id = bcpd.pl_id