APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_OIPL_F

Line 317: --updates elig_apls_flag to 'Y' in ben_oipl_f table.

313: --
314: hr_utility.set_location(' update of pl_f ' , 60);
315: --
316: elsif l_oipl_id is not null then
317: --updates elig_apls_flag to 'Y' in ben_oipl_f table.
318: update ben_oipl_f c
319: set c.elig_apls_flag = 'Y'
320: where c.business_group_id = p_business_group_id
321: and c.elig_apls_flag <> 'Y'

Line 318: update ben_oipl_f c

314: hr_utility.set_location(' update of pl_f ' , 60);
315: --
316: elsif l_oipl_id is not null then
317: --updates elig_apls_flag to 'Y' in ben_oipl_f table.
318: update ben_oipl_f c
319: set c.elig_apls_flag = 'Y'
320: where c.business_group_id = p_business_group_id
321: and c.elig_apls_flag <> 'Y'
322: and c.oipl_id = l_oipl_id ;

Line 353: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl_id);

349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);
350: end if;
351: --
352: if l_oipl_id is not null then
353: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl_id);
354: end if;
355: --
356: -- Set all output arguments
357: p_prtn_elig_prfl_id := l_prtn_elig_prfl_id;

Line 489: from ben_oipl_f

485:
486:
487: cursor c_oipl_flag (c_id number) is
488: select drvbl_fctr_prtn_elig_flag
489: from ben_oipl_f
490: where oipl_id = c_id
491: and p_effective_date between effective_start_date and effective_end_date ;
492:
493: --

Line 784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);

780: hr_utility.set_location( ' old oipl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
781:
782:
783: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
785: else
786: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
787: end if;
788:

Line 786: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

782:
783: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
785: else
786: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
787: end if;
788:
789: end if;
790: end if ;

Line 1027: --updates elig_apls_flag to 'N' in ben_oipl_f table only when

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.
1029: elsif l_c1.oipl_id is not null then
1030: update ben_oipl_f c
1031: set c.elig_apls_flag = 'N'

Line 1030: update ben_oipl_f c

1026: --
1027: --updates elig_apls_flag to 'N' in ben_oipl_f table only when
1028: --no record found in profile and rule tables.
1029: elsif l_c1.oipl_id is not null then
1030: update ben_oipl_f c
1031: set c.elig_apls_flag = 'N'
1032: where not exists
1033: (select a.oipl_id
1034: from ben_prtn_elig_f a,

Line 1047: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

1043: and a.oipl_id = c.oipl_id)
1044: and c.oipl_id = l_c1.oipl_id;
1045: --
1046: -- updates drvbl_fctr_prtn_elig_flag
1047: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
1048: --
1049: end if;
1050: --
1051: hr_utility.set_location(l_proc, 60);