APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_PLIP_F

Line 288: --updates elig_apls_flag to 'Y' in ben_plip_f table.

284: hr_utility.set_location(' update of pgm_f ' , 60);
285: --
286: elsif l_plip_id is not null then
287: --
288: --updates elig_apls_flag to 'Y' in ben_plip_f table.
289: update ben_plip_f c
290: set c.elig_apls_flag = 'Y'
291: where c.business_group_id = p_business_group_id
292: and c.elig_apls_flag <> 'Y'

Line 289: update ben_plip_f c

285: --
286: elsif l_plip_id is not null then
287: --
288: --updates elig_apls_flag to 'Y' in ben_plip_f table.
289: update ben_plip_f c
290: set c.elig_apls_flag = 'Y'
291: where c.business_group_id = p_business_group_id
292: and c.elig_apls_flag <> 'Y'
293: and c.plip_id = l_plip_id ;

Line 345: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_plip_id);

341: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_pl_id);
342: end if;
343: --
344: if l_plip_id is not null then
345: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_plip_id);
346: end if;
347: --
348: if l_ptip_id is not null then
349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);

Line 476: from ben_plip_f

472: and p_effective_date between effective_start_date and effective_end_date ;
473:
474: cursor c_plip_flag (c_id number) is
475: select drvbl_fctr_prtn_elig_flag
476: from ben_plip_f
477: where plip_id = c_id
478: and p_effective_date between effective_start_date and effective_end_date ;
479:
480: cursor c_ptip_flag (c_id number) is

Line 753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);

749:
750: hr_utility.set_location( ' old plip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
751:
752: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
754: else
755: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
756: end if ;
757: end if;

Line 755: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);

751:
752: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
754: else
755: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
756: end if ;
757: end if;
758: --
759: if l_c1.ptip_id is not null then

Line 958: --updates elig_apls_flag to 'N' in ben_plip_f table only when

954: and c.pgm_id = l_c1.pgm_id;
955: -- updates drvbl_fctr_prtn_elig_flag
956: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
957: --
958: --updates elig_apls_flag to 'N' in ben_plip_f table only when
959: --no record found in profile and rule tables.
960: elsif l_c1.plip_id is not null then
961: --
962: update ben_plip_f c

Line 962: update ben_plip_f c

958: --updates elig_apls_flag to 'N' in ben_plip_f table only when
959: --no record found in profile and rule tables.
960: elsif l_c1.plip_id is not null then
961: --
962: update ben_plip_f c
963: set c.elig_apls_flag = 'N'
964: where not exists
965: (select a.plip_id
966: from ben_prtn_elig_f a,

Line 979: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);

975: and a.plip_id = c.plip_id)
976: and c.plip_id = l_c1.plip_id;
977: --
978: -- updates drvbl_fctr_prtn_elig_flag
979: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
980: --
981: --
982: --updates elig_apls_flag to 'N' in ben_ptip_f table only when
983: --no record found in profile and rule tables.