APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_OIPL_F

Line 314: From BEN_OIPL_F

310:
311: Cursor csr_opt_id
312: IS
313: Select Opt_Id
314: From BEN_OIPL_F
315: Where OIPL_ID = p_oipl_id
316: And OIPL_STAT_CD = 'A'
317: AND BUSINESS_GROUP_ID = p_business_group_id
318: AND p_effective_date BETWEEN EFFECTIVE_START_DATE

Line 442: From BEN_OIPL_F oipl,

438: Cursor csr_grade_point_id
439: IS
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'

Line 836: BEN_OIPL_F oipl,

832: Cursor csr_opt_in_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

Line 913: BEN_OIPL_F oipl

909: Cursor csr_pl_id
910: IS
911: Select oipl.PL_ID
912: FROM BEN_OPT_F opt,
913: BEN_OIPL_F oipl
914: WHERE opt.opt_id = p_opt_id
915: AND opt.Business_group_id = p_Business_Group_Id
916: AND opt.opt_id = oipl.opt_id
917: And oipl.OIPL_STAT_CD = 'A'

Line 1923: From BEN_OIPL_F

1919:
1920: Cursor csr_oipl_id
1921: IS
1922: Select oipl_id
1923: From BEN_OIPL_F
1924: Where opt_id = p_opt_id
1925: AND Business_group_id = p_business_group_id
1926: AND p_effective_date BETWEEN effective_start_date
1927: AND nvl(effective_end_date,hr_general.end_of_time)

Line 2127: l_status BEN_OIPL_F.OIPL_STAT_CD%Type;

2123: If OIPL is mapped to Step and the step have employee assignments.
2124:
2125: */
2126: l_proc Varchar2(72) := g_package||'oipl_upd_val';
2127: l_status BEN_OIPL_F.OIPL_STAT_CD%Type;
2128: l_emp_exists Varchar2(1) := 'N';
2129: l_oipl_has_gsp_type Varchar2(1) := 'N';
2130:
2131: Begin

Line 2368: From BEN_OIPL_F

2364:
2365: Cursor csr_oipl_id
2366: IS
2367: Select OIPL_ID
2368: From BEN_OIPL_F
2369: Where OPT_ID = p_opt_id
2370: And Business_Group_Id = p_business_group_id
2371: And p_effective_date BETWEEN effective_start_date
2372: AND nvl(effective_end_date,hr_general.end_of_time);