APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PL_F

Line 26: From Ben_PL_F pl

22:
23: Cursor csr_pl_type_id
24: IS
25: Select pl.Pl_Typ_Id
26: From Ben_PL_F pl
27: Where pl.Pl_Id = p_pl_id
28: And pl.Business_Group_id = p_Business_Group_Id
29: And p_effective_date BETWEEN Pl.effective_start_date
30: And nvl(Pl.effective_end_date,hr_general.end_of_time);

Line 169: BEN_PL_F PL

165: Cursor csr_grade_id
166: IS
167: SELECT MAPPING_TABLE_PK_ID -- GRADE_ID
168: FROM BEN_PLIP_F PLIP,
169: BEN_PL_F PL
170: WHERE PLIP.PLIP_ID = p_plip_id
171: And PLIP.PLIP_STAT_CD ='A'
172: AND PLIP.PL_ID =PL.PL_ID
173: AND PL.MAPPING_TABLE_NAME = 'PER_GRADES'

Line 444: BEN_PL_F pl

440: Select pl.MAPPING_TABLE_PK_ID, -- Grade_Id
441: opt.MAPPING_TABLE_PK_ID -- spinal_point_id
442: From BEN_OIPL_F oipl,
443: BEN_OPT_F opt,
444: BEN_PL_F pl
445: Where oipl.Oipl_Id = p_oipl_id
446: And oipl.OIPL_STAT_CD = 'A'
447: And oipl.Pl_id = pl.PL_ID
448: And oipl.Business_Group_Id= p_business_group_id

Line 707: BEN_PL_F PL

703: IS
704: Select NULL
705: From BEN_PGM_F PGM,
706: BEN_PLIP_F PLIP,
707: BEN_PL_F PL
708: WHERE PGM.PGM_ID = p_Pgm_Id
709: AND PGM.PGM_TYP_CD = 'GSP'
710: AND PGM.BUSINESS_GROUP_ID = p_Business_Group_Id
711: AND PGM.PGM_ID = PLIP.PGM_ID

Line 766: From Ben_PL_F pl,

762:
763: Cursor csr_pl_in_grdldr
764: IS
765: Select Null
766: From Ben_PL_F pl,
767: Ben_Plip_F plip,
768: Ben_Pgm_F Pgm
769: Where pl.pl_id = p_pl_id
770: And pl.MAPPING_TABLE_NAME = 'PER_GRADES'

Line 837: BEN_PL_F pl

833: IS
834: Select Null
835: FROM BEN_OPT_F opt,
836: BEN_OIPL_F oipl,
837: BEN_PL_F pl
838: WHERE opt.opt_id = p_opt_id
839: AND opt.Business_group_id = p_Business_Group_Id
840: AND opt.opt_id = oipl.opt_id
841: AND oipl.pl_id = pl.pl_id

Line 1442: l_grade_id BEN_PL_F.Mapping_Table_PK_ID%Type;

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';
1446: l_plan_Typ_Id Number;

Line 1443: l_status BEN_PL_F.PL_STAT_CD%Type;

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';
1446: l_plan_Typ_Id Number;
1447: