APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PLIP_F

Line 90: From Ben_PLIP_F plip

86:
87: Cursor csr_pl_id
88: IS
89: Select plip.Pl_Id,plip.Pgm_Id
90: From Ben_PLIP_F plip
91: Where plip.Plip_Id = p_plip_id
92: And plip.Business_Group_id = p_Business_Group_Id
93: And p_effective_date BETWEEN Plip.effective_start_date
94: And nvl(Plip.effective_end_date,hr_general.end_of_time);

Line 168: FROM BEN_PLIP_F PLIP,

164:
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

Line 706: BEN_PLIP_F PLIP,

702: Cursor csr_grades
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

Line 767: Ben_Plip_F plip,

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'
771: And pl.MAPPING_TABLE_PK_ID IS NOT NULL

Line 1463: From BEN_PLIP_F

1459:
1460: Cursor csr_plip_id
1461: IS
1462: Select PLIP_ID
1463: From BEN_PLIP_F
1464: Where Pl_Id = p_pl_Id
1465: And business_group_id = p_business_group_id
1466: And p_effective_date Between Effective_Start_Date
1467: And nvl(Effective_End_Date, hr_general.end_of_time)

Line 1713: l_status Ben_PlIP_F.PLIP_STAT_CD%Type;

1709:
1710: */
1711: l_proc Varchar2(72) := g_package||'plip_upd_val';
1712: l_exists Varchar2(1) :='N';
1713: l_status Ben_PlIP_F.PLIP_STAT_CD%Type;
1714:
1715:
1716: Begin
1717: if g_debug then

Line 2357: From BEN_PLIP_F

2353:
2354: Cursor csr_plip_id
2355: IS
2356: Select PLIP_ID
2357: From BEN_PLIP_F
2358: Where PL_ID = p_pl_id
2359: AND PLIP_STAT_CD = 'A'
2360: And Business_Group_Id = p_business_group_id
2361: And p_effective_date BETWEEN effective_start_date