APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_ACTY_BASE_RT_F

Line 2338: l_status BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_STAT_CD%Type;

2334: 2. Cannot Update Activity Type
2335:
2336: */
2337: l_proc Varchar2(72) := g_package||'abr_upd_val';
2338: l_status BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_STAT_CD%Type;
2339: l_activity BEN_ACTY_BASE_RT_F.ACTY_TYP_CD%Type;
2340: l_plip_id Number;
2341: l_oipl_id Number;
2342:

Line 2339: l_activity BEN_ACTY_BASE_RT_F.ACTY_TYP_CD%Type;

2335:
2336: */
2337: l_proc Varchar2(72) := g_package||'abr_upd_val';
2338: l_status BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_STAT_CD%Type;
2339: l_activity BEN_ACTY_BASE_RT_F.ACTY_TYP_CD%Type;
2340: l_plip_id Number;
2341: l_oipl_id Number;
2342:
2343: l_pl_exists_in_grdldr Varchar2(1) := 'N';

Line 2534: l_activity_type BEN_ACTY_BASE_RT_F.ACTY_TYP_CD%Type;

2530: /*
2531: Purpose : To Perform these Validations.
2532: */
2533: l_proc Varchar2(72) := g_package||'abr_validations';
2534: l_activity_type BEN_ACTY_BASE_RT_F.ACTY_TYP_CD%Type;
2535:
2536: Cursor csr_activity_type
2537: IS
2538: Select ACTY_TYP_CD

Line 2539: From BEN_ACTY_BASE_RT_F

2535:
2536: Cursor csr_activity_type
2537: IS
2538: Select ACTY_TYP_CD
2539: From BEN_ACTY_BASE_RT_F
2540: Where ACTY_BASE_RT_ID = p_abr_id
2541: And Business_Group_Id = p_business_group_id
2542: And p_effective_date BETWEEN effective_start_date
2543: AND nvl(effective_end_date,hr_general.end_of_time);