APPS.BEN_CWB_UTILS dependencies on BEN_CWB_PL_DSGN

Line 964: From ben_cwb_pl_dsgn

960: p_ws_sub_acty_typ_cd in varchar2) return varchar2
961: is
962: cursor cur_option1_name is
963: Select name
964: From ben_cwb_pl_dsgn
965: Where pl_id = p_group_plan_id
966: and group_pl_id = p_group_plan_id
967: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
968: --And oipl_id <> -1

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 1263: From ben_cwb_pl_dsgn

1259: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1260: is
1261: cursor cur_option2_name is
1262: Select name
1263: From ben_cwb_pl_dsgn
1264: Where pl_id = p_group_plan_id
1265: And group_pl_id = p_group_plan_id
1266: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1267: -- And oipl_id <> -1

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 1562: From ben_cwb_pl_dsgn

1558: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1559: is
1560: cursor cur_option3_name is
1561: Select name
1562: From ben_cwb_pl_dsgn
1563: Where pl_id = p_group_plan_id
1564: And group_pl_id = p_group_plan_id
1565: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1566: -- And oipl_id <> -1

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 1859: From ben_cwb_pl_dsgn

1855: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1856: is
1857: cursor cur_option4_name is
1858: Select name
1859: From ben_cwb_pl_dsgn
1860: Where pl_id = p_group_plan_id
1861: And group_pl_id = p_group_plan_id
1862: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1863: -- And oipl_id <> -1

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 2738: from ben_cwb_pl_dsgn

2734: p_plan_id in number ,
2735: p_lf_evt_ocrd_dt in date ) return varchar2 is
2736: cursor c_doc_short_name is
2737: select pqh_document_short_name
2738: from ben_cwb_pl_dsgn
2739: where pl_id = p_plan_id
2740: and oipl_id = -1
2741: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
2742:

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