APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PL_TYP

Line 20: l_type BEN_PL_TYP.OPT_TYP_CD%Type := NULL;

16: p_effective_date In date,
17: p_Business_Group_Id In Number)
18: Return Varchar2 IS
19: l_proc Varchar2(72) := g_package||'get_pl_type';
20: l_type BEN_PL_TYP.OPT_TYP_CD%Type := NULL;
21: l_type_id Number;
22:
23: Cursor csr_pl_type_id
24: IS

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 83: l_type BEN_PL_TYP.OPT_TYP_CD%Type := NULL;

79: p_Business_Group_Id In Number)
80: Return Varchar2 IS
81: l_proc Varchar2(72) := g_package||'get_plip_type';
82: l_pl_id Number;
83: l_type BEN_PL_TYP.OPT_TYP_CD%Type := NULL;
84: l_pgm_id Number;
85: l_is_pgm_type_gsp Varchar2(1) :='N';
86:
87: Cursor csr_pl_id

Line 162: l_plip_type_cd BEN_PL_TYP.OPT_TYP_CD%Type := NULL;

158: */
159: l_proc Varchar2(72) := g_package||'chk_plip_emp_assign';
160: l_grade_id Number;
161: l_dummy Char(1);
162: l_plip_type_cd BEN_PL_TYP.OPT_TYP_CD%Type := NULL;
163: l_exists Varchar2(1) :='N';
164:
165: Cursor csr_grade_id
166: IS

Line 261: From BEN_PL_TYP_OPT_TYP_F

257:
258: Cursor csr_opt_type
259: IS
260: Select NULL
261: From BEN_PL_TYP_OPT_TYP_F
262: Where OPT_ID = p_opt_id
263: AND BUSINESS_GROUP_ID = p_business_group_id
264: AND p_effective_date BETWEEN EFFECTIVE_START_DATE
265: And nvl(Effective_End_Date, hr_general.end_of_time)

Line 1440: l_exist_pl_type_cd BEN_PL_TYP.OPT_TYP_CD%Type;

1436:
1437: */
1438: l_proc Varchar2(72) := g_package||'pl_upd_val';
1439: l_exists Varchar2(10);
1440: l_exist_pl_type_cd BEN_PL_TYP.OPT_TYP_CD%Type;
1441: l_new_pl_type_cd BEN_PL_TYP.OPT_TYP_CD%Type;
1442: l_grade_id BEN_PL_F.Mapping_Table_PK_ID%Type;
1443: l_status BEN_PL_F.PL_STAT_CD%Type;
1444: l_plip_id Number;

Line 1441: l_new_pl_type_cd BEN_PL_TYP.OPT_TYP_CD%Type;

1437: */
1438: l_proc Varchar2(72) := g_package||'pl_upd_val';
1439: l_exists Varchar2(10);
1440: l_exist_pl_type_cd BEN_PL_TYP.OPT_TYP_CD%Type;
1441: l_new_pl_type_cd BEN_PL_TYP.OPT_TYP_CD%Type;
1442: l_grade_id BEN_PL_F.Mapping_Table_PK_ID%Type;
1443: l_status BEN_PL_F.PL_STAT_CD%Type;
1444: l_plip_id Number;
1445: l_emp_exists Varchar2(1) :='N';

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);