APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on BEN_PL_TYP_F

Line 417: From ben_pl_typ_f

413: --
414: --
415: Cursor get_pl_typ is
416: Select pl_typ_id
417: From ben_pl_typ_f
418: Where opt_typ_cd = 'GSP'
419: and business_group_id = p_business_group_id
420: and l_effective_date between effective_start_date and effective_end_date;
421:

Line 428: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

424: l_ovn_no ben_Opt_F.Object_Version_Number%TYPE;
425: L_opt_id ben_opt_F.Opt_Id%TYPE;
426: l_opt_exists varchar2(10);
427: --
428: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
429: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%type;
430: l_continue boolean;
431: --
432: Begin