APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_PL_F

Line 307: --updates elig_apls_flag to 'Y' in ben_pl_f table.

303: and c.ptip_id = l_ptip_id ;
304: hr_utility.set_location(' update of ptip_f ' , 60);
305: --
306: elsif l_pl_id is not null then
307: --updates elig_apls_flag to 'Y' in ben_pl_f table.
308: update ben_pl_f c
309: set c.elig_apls_flag = 'Y'
310: where c.business_group_id = p_business_group_id
311: and c.elig_apls_flag <> 'Y'

Line 308: update ben_pl_f c

304: hr_utility.set_location(' update of ptip_f ' , 60);
305: --
306: elsif l_pl_id is not null then
307: --updates elig_apls_flag to 'Y' in ben_pl_f table.
308: update ben_pl_f c
309: set c.elig_apls_flag = 'Y'
310: where c.business_group_id = p_business_group_id
311: and c.elig_apls_flag <> 'Y'
312: and c.pl_id = l_pl_id ;

Line 341: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_pl_id);

337: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_pgm_id);
338: end if;
339: --
340: if l_pl_id is not null then
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);

Line 470: from ben_pl_f

466: and p_effective_date between effective_start_date and effective_end_date ;
467:
468: cursor c_pl_flag (c_id number) is
469: select drvbl_fctr_prtn_elig_flag
470: from ben_pl_f
471: where pl_id = c_id
472: and p_effective_date between effective_start_date and effective_end_date ;
473:
474: cursor c_plip_flag (c_id number) is

Line 738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);

734: hr_utility.set_location( ' old pl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
735:
736:
737: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
739: else
740: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
741: end if ;
742: end if;

Line 740: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);

736:
737: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
739: else
740: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
741: end if ;
742: end if;
743: --
744: if l_c1.plip_id is not null then

Line 1004: --updates elig_apls_flag to 'N' in ben_pl_f table only when

1000: --
1001: -- updates drvbl_fctr_prtn_elig_flag
1002: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
1003: --
1004: --updates elig_apls_flag to 'N' in ben_pl_f table only when
1005: --no record found in profile and rule tables.
1006: elsif l_c1.pl_id is not null then
1007: update ben_pl_f c
1008: set c.elig_apls_flag = 'N'

Line 1007: update ben_pl_f c

1003: --
1004: --updates elig_apls_flag to 'N' in ben_pl_f table only when
1005: --no record found in profile and rule tables.
1006: elsif l_c1.pl_id is not null then
1007: update ben_pl_f c
1008: set c.elig_apls_flag = 'N'
1009: where not exists
1010: (select a.pl_id
1011: from ben_prtn_elig_f a,

Line 1024: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);

1020: and a.pl_id = c.pl_id)
1021: and c.pl_id = l_c1.pl_id;
1022: --
1023: -- updates drvbl_fctr_prtn_elig_flag
1024: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
1025: --
1026: --
1027: --updates elig_apls_flag to 'N' in ben_oipl_f table only when
1028: --no record found in profile and rule tables.