APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PL_TYP_F

Line 35: From BEN_PL_TYP_F Type

31:
32: Cursor csr_pl_type (l_pl_Typ_Id IN Number)
33: IS
34: Select OPT_TYP_CD
35: From BEN_PL_TYP_F Type
36: Where Pl_Typ_Id = l_pl_Typ_Id
37: And Business_Group_id = p_Business_Group_Id
38: And p_effective_date BETWEEN effective_start_date
39: And nvl(effective_end_date,hr_general.end_of_time);

Line 1453: From BEN_PL_TYP_F Type

1449:
1450: Cursor csr_pl_type (l_plan_Typ_Id IN Number)
1451: IS
1452: Select OPT_TYP_CD
1453: From BEN_PL_TYP_F Type
1454: Where Pl_Typ_Id = l_plan_Typ_Id
1455: And Business_Group_id = p_business_group_id
1456: And p_effective_date BETWEEN effective_start_date
1457: And nvl(effective_end_date,hr_general.end_of_time);