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_PDP_BUS dependencies on BEN_PL_F

Line 873: FROM ben_pl_f pl

869: --
870: CURSOR c_plan
871: IS
872: SELECT pl.dpnt_dsgn_cd
873: FROM ben_pl_f pl
874: WHERE pl.pl_id = rslt_pl_id
875: AND pl.business_group_id = p_business_group_id
876: AND p_effective_date BETWEEN pl.effective_start_date
877: AND pl.effective_end_date;

Line 895: FROM ben_pl_f pl

891: --
892: CURSOR c_plan_flag
893: IS
894: SELECT pl.alws_qmcso_flag, pl.alws_qdro_flag, pl.pl_typ_id
895: FROM ben_pl_f pl
896: WHERE pl.pl_id = rslt_pl_id
897: AND pl.business_group_id = p_business_group_id
898: AND p_effective_date BETWEEN pl.effective_start_date
899: AND pl.effective_end_date;

Line 923: ben_pl_f bpl

919: ben_crt_ordr_cvrd_per cvr,
920: per_all_people_f per,
921: per_contact_relationships con,
922: hr_lookups lkp,
923: ben_pl_f bpl
924: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
925: AND crt.person_id = rslt_person_id
926: AND crt.pl_id = rslt_pl_id
927: AND crt.crt_ordr_id = cvr.crt_ordr_id