APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_PTIP_F

Line 298: --updates elig_apls_flag to 'Y' in ben_ptip_f table.

294: --
295: hr_utility.set_location(' update of plip_f ' , 60);
296: --
297: elsif l_ptip_id is not null then
298: --updates elig_apls_flag to 'Y' in ben_ptip_f table.
299: update ben_ptip_f c
300: set c.elig_apls_flag = 'Y'
301: where c.business_group_id = p_business_group_id
302: and c.elig_apls_flag <> 'Y'

Line 299: update ben_ptip_f c

295: hr_utility.set_location(' update of plip_f ' , 60);
296: --
297: elsif l_ptip_id is not null then
298: --updates elig_apls_flag to 'Y' in ben_ptip_f table.
299: update ben_ptip_f c
300: set c.elig_apls_flag = 'Y'
301: where c.business_group_id = p_business_group_id
302: and c.elig_apls_flag <> 'Y'
303: and c.ptip_id = l_ptip_id ;

Line 349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);

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);
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);

Line 482: from ben_ptip_f

478: and p_effective_date between effective_start_date and effective_end_date ;
479:
480: cursor c_ptip_flag (c_id number) is
481: select drvbl_fctr_prtn_elig_flag
482: from ben_ptip_f
483: where ptip_id = c_id
484: and p_effective_date between effective_start_date and effective_end_date ;
485:
486:

Line 768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);

764:
765: hr_utility.set_location( ' old ptip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
766:
767: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
769: else
770: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
771: end if ;
772: end if;

Line 770: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);

766:
767: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
769: else
770: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
771: end if ;
772: end if;
773: --
774: if l_c1.oipl_id is not null then

Line 982: --updates elig_apls_flag to 'N' in ben_ptip_f table only when

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.
984: elsif l_c1.ptip_id is not null then
985: update ben_ptip_f c
986: set c.elig_apls_flag = 'N'

Line 985: update ben_ptip_f c

981: --
982: --updates elig_apls_flag to 'N' in ben_ptip_f table only when
983: --no record found in profile and rule tables.
984: elsif l_c1.ptip_id is not null then
985: update ben_ptip_f c
986: set c.elig_apls_flag = 'N'
987: where not exists
988: (select a.ptip_id
989: from ben_prtn_elig_f a,

Line 1002: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);

998: and a.ptip_id = c.ptip_id)
999: and c.ptip_id = l_c1.ptip_id;
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