APPS.BEN_CWB_WEBADI_UTILS dependencies on BEN_CWB_PL_DSGN

Line 353: from ben_cwb_pl_dsgn

349: ,max(ws_abr_id) ws_abr_id
350: ,max(elig_sal_abr_id) elig_sal_abr_id
351: ,max(ws_nnmntry_uom) ws_nnmntry_uom
352: ,null ws_sub_acty_typ_cd
353: from ben_cwb_pl_dsgn
354: where group_pl_id = p_group_pl_id
355: and group_pl_id = pl_id
356: and group_oipl_id = oipl_id
357: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 367: from ben_cwb_pl_dsgn

363: ,max(ws_abr_id) ws_abr_id
364: ,max(elig_sal_abr_id) elig_sal_abr_id
365: ,max(ws_nnmntry_uom) ws_nnmntry_uom
366: ,null ws_sub_acty_typ_cd
367: from ben_cwb_pl_dsgn
368: where group_pl_id = p_group_pl_id
369: and group_pl_id = pl_id
370: and group_oipl_id <> oipl_id
371: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 381: from ben_cwb_pl_dsgn

377: ,max(ws_abr_id) ws_abr_id
378: ,max(elig_sal_abr_id) elig_sal_abr_id
379: ,max(ws_nnmntry_uom) ws_nnmntry_uom
380: ,null ws_sub_acty_typ_cd
381: from ben_cwb_pl_dsgn
382: where group_pl_id = p_group_pl_id
383: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
384: and group_oipl_id <> -1
385: and oipl_ordr_num = 1;

Line 394: from ben_cwb_pl_dsgn

390: ,max(ws_abr_id) ws_abr_id
391: ,max(elig_sal_abr_id) elig_sal_abr_id
392: ,max(ws_nnmntry_uom) ws_nnmntry_uom
393: ,null ws_sub_acty_typ_cd
394: from ben_cwb_pl_dsgn
395: where group_pl_id = p_group_pl_id
396: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
397: and group_oipl_id <> -1
398: and oipl_ordr_num = 2;

Line 407: from ben_cwb_pl_dsgn

403: ,max(ws_abr_id) ws_abr_id
404: ,max(elig_sal_abr_id) elig_sal_abr_id
405: ,max(ws_nnmntry_uom) ws_nnmntry_uom
406: ,null ws_sub_acty_typ_cd
407: from ben_cwb_pl_dsgn
408: where group_pl_id = p_group_pl_id
409: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
410: and group_oipl_id <> -1
411: and oipl_ordr_num = 3;

Line 420: from ben_cwb_pl_dsgn

416: ,max(ws_abr_id) ws_abr_id
417: ,max(elig_sal_abr_id) elig_sal_abr_id
418: ,max(ws_nnmntry_uom) ws_nnmntry_uom
419: ,null ws_sub_acty_typ_cd
420: from ben_cwb_pl_dsgn
421: where group_pl_id = p_group_pl_id
422: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
423: and group_oipl_id <> -1
424: and oipl_ordr_num = 4;

Line 433: from ben_cwb_pl_dsgn

429: ,max(ws_abr_id) ws_abr_id
430: ,max(elig_sal_abr_id) elig_sal_abr_id
431: ,max(ws_nnmntry_uom) ws_nnmntry_uom
432: ,max(ws_sub_acty_typ_cd) ws_sub_acty_typ_cd
433: from ben_cwb_pl_dsgn
434: where group_pl_id = p_group_pl_id
435: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
436: and group_pl_id <> pl_id
437: and group_oipl_id = -1

Line 447: from ben_cwb_pl_dsgn

443: ,max(ws_abr_id) ws_abr_id
444: ,max(elig_sal_abr_id) elig_sal_abr_id
445: ,max(ws_nnmntry_uom) ws_nnmntry_uom
446: ,max(ws_sub_acty_typ_cd) ws_sub_acty_typ_cd
447: from ben_cwb_pl_dsgn
448: where group_pl_id = p_group_pl_id
449: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
450: and group_pl_id = pl_id
451: and group_oipl_id = -1