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_UTILS dependencies on BEN_CWB_PL_DSGN

Line 457: From ben_cwb_pl_dsgn

453: p_ws_sub_acty_typ_cd in varchar2) return varchar2
454: is
455: cursor cur_option1_name is
456: Select name
457: From ben_cwb_pl_dsgn
458: Where pl_id = p_group_plan_id
459: and group_pl_id = p_group_plan_id
460: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
461: --And oipl_id <> -1

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

752: p_ws_sub_acty_typ_cd in varchar2) return varchar2
753: is
754: cursor cur_option2_name is
755: Select name
756: From ben_cwb_pl_dsgn
757: Where pl_id = p_group_plan_id
758: And group_pl_id = p_group_plan_id
759: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
760: -- And oipl_id <> -1

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

1051: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1052: is
1053: cursor cur_option3_name is
1054: Select name
1055: From ben_cwb_pl_dsgn
1056: Where pl_id = p_group_plan_id
1057: And group_pl_id = p_group_plan_id
1058: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1059: -- And oipl_id <> -1

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

1348: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1349: is
1350: cursor cur_option4_name is
1351: Select name
1352: From ben_cwb_pl_dsgn
1353: Where pl_id = p_group_plan_id
1354: And group_pl_id = p_group_plan_id
1355: And lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1356: -- And oipl_id <> -1

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

2227: p_plan_id in number ,
2228: p_lf_evt_ocrd_dt in date ) return varchar2 is
2229: cursor c_doc_short_name is
2230: select pqh_document_short_name
2231: from ben_cwb_pl_dsgn
2232: where pl_id = p_plan_id
2233: and oipl_id = -1
2234: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
2235:

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