APPS.PQH_RBC_LOAD_OBJECTS dependencies on BEN_PL_TYP_F

Line 41: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

37: ) is
38:
39: --
40: l_pl_id ben_pl_f.pl_id%type ;
41: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
42: l_ovn number ;
43: l_effective_start_date date ;
44: l_effective_end_date date ;
45: l_effective_date date;

Line 68: From ben_pl_typ_f

64: -- There can be only one plan type in the business group with option type = 'RBC'
65: --
66: Cursor csr_pl_typ is
67: select pl_typ_id
68: From ben_pl_typ_f
69: Where opt_typ_cd = 'RBC'
70: and l_effective_date between effective_start_date and effective_end_date
71: and business_group_id = l_business_group_id;
72: --