APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on HR_API

Line 145: and pen.effective_end_date = hr_api.g_eot;

141: /* Bug#2903964 - it is better to get the results based on effective end date rather
142: filtering on effective_date
143: and p_effective_date between
144: pen.effective_start_date and pen.effective_end_date */
145: and pen.effective_end_date = hr_api.g_eot;
146: l_people c_people%rowtype;
147:
148: cursor c_vrbl_val (p_vrbl_rt_prfl_id number) is
149: select nvl(vpf.val,0) val, vpf.upr_lmt_val, vpf.upr_lmt_calc_rl

Line 537: and pen.effective_end_date = hr_api.g_eot;

533: /* Bug#2903964 - it is better to get the results based on effective end date rather
534: filtering on effective_date
535: and p_effective_date between
536: pen.effective_start_date and pen.effective_end_date */
537: and pen.effective_end_date = hr_api.g_eot;
538: l_results c_results%rowtype;
539: --
540: -- participants that have this coverage this month that should be
541: -- paying the premium. Used when we need to allocate prem to each participant.

Line 587: and pen.effective_end_date = hr_api.g_eot;

583: /* Bug#2903964 - it is better to get the results based on effective end date rather
584: filtering on effective_date
585: and p_effective_date between
586: pen.effective_start_date and pen.effective_end_date*/
587: and pen.effective_end_date = hr_api.g_eot;
588: l_each_result c_each_result%rowtype;
589:
590: -- participant prem row:
591: cursor c_ppe (p_prtt_enrt_rslt_id number

Line 948: ,p_datetrack_mode => hr_api.g_correction);

944: ,p_program_application_id => fnd_global.prog_appl_id
945: ,p_program_id => fnd_global.conc_program_id
946: ,p_program_update_date => sysdate
947: ,p_effective_date => l_last_effective_dt
948: ,p_datetrack_mode => hr_api.g_correction);
949:
950: else
951:
952: ben_prtt_prem_by_mo_api.update_prtt_prem_by_mo

Line 967: ,p_datetrack_mode => hr_api.g_correction);

963: ,p_program_application_id => fnd_global.prog_appl_id
964: ,p_program_id => fnd_global.conc_program_id
965: ,p_program_update_date => sysdate
966: ,p_effective_date => l_last_effective_dt
967: ,p_datetrack_mode => hr_api.g_correction);
968: end if ;
969: end if ;
970: end if;
971: close c_prm;

Line 1053: ,p_datetrack_mode => hr_api.g_correction);

1049: ,p_program_application_id => fnd_global.prog_appl_id
1050: ,p_program_id => fnd_global.conc_program_id
1051: ,p_program_update_date => sysdate
1052: ,p_effective_date => l_effective_date_mo -- p_effective_date
1053: ,p_datetrack_mode => hr_api.g_correction);
1054: end if;
1055: close c_pbm;
1056: -- write info to reporting table
1057: g_rec.rep_typ_cd := 'PRPLOIPL';