DBA Data[Home] [Help]

APPS.BEN_FORFEITURE_CONCURRENT dependencies on HR_API

Line 423: and ( (pen.enrt_cvg_thru_dt = hr_api.g_eot

419: and per.effective_end_date
420: and pen.prtt_enrt_rslt_stat_cd is null
421: and pen.sspndd_flag = 'N'
422: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
423: and ( (pen.enrt_cvg_thru_dt = hr_api.g_eot
424: and pen.effective_end_date = hr_api.g_eot
425: and pen.enrt_cvg_strt_dt < p_end_date
426: )
427: or(pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 424: and pen.effective_end_date = hr_api.g_eot

420: and pen.prtt_enrt_rslt_stat_cd is null
421: and pen.sspndd_flag = 'N'
422: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
423: and ( (pen.enrt_cvg_thru_dt = hr_api.g_eot
424: and pen.effective_end_date = hr_api.g_eot
425: and pen.enrt_cvg_strt_dt < p_end_date
426: )
427: or(pen.enrt_cvg_thru_dt = hr_api.g_eot
428: and pen.effective_end_date between p_start_date and p_end_date

Line 427: or(pen.enrt_cvg_thru_dt = hr_api.g_eot

423: and ( (pen.enrt_cvg_thru_dt = hr_api.g_eot
424: and pen.effective_end_date = hr_api.g_eot
425: and pen.enrt_cvg_strt_dt < p_end_date
426: )
427: or(pen.enrt_cvg_thru_dt = hr_api.g_eot
428: and pen.effective_end_date between p_start_date and p_end_date
429: and pen.enrt_cvg_strt_dt < p_end_date
430: )
431: or(pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 431: or(pen.enrt_cvg_thru_dt = hr_api.g_eot

427: or(pen.enrt_cvg_thru_dt = hr_api.g_eot
428: and pen.effective_end_date between p_start_date and p_end_date
429: and pen.enrt_cvg_strt_dt < p_end_date
430: )
431: or(pen.enrt_cvg_thru_dt = hr_api.g_eot
432: and pen.effective_end_date between p_start_date and p_end_date
433: and pen.enrt_cvg_strt_dt between p_start_date and p_end_date
434: )
435: )

Line 866: hr_api.g_eot,

862: ) values
863: (
864: ben_pl_frfs_val_f_s.nextval,
865: p_effective_date,
866: hr_api.g_eot,
867: p_business_group_id,
868: p_pl_id,
869: l_start_date,
870: l_end_date,

Line 1687: hr_api.mandatory_arg_error(p_api_name => g_package

1683: -- such as p_business_group_id, p_mode, p_effective_date
1684: --
1685: l_actn := 'Checking arguments...';
1686: hr_utility.set_location('Checking arguments',12);
1687: hr_api.mandatory_arg_error(p_api_name => g_package
1688: ,p_argument => 'p_business_group_id'
1689: ,p_argument_value => p_business_group_id
1690: );
1691: hr_api.mandatory_arg_error(p_api_name => g_package

Line 1691: hr_api.mandatory_arg_error(p_api_name => g_package

1687: hr_api.mandatory_arg_error(p_api_name => g_package
1688: ,p_argument => 'p_business_group_id'
1689: ,p_argument_value => p_business_group_id
1690: );
1691: hr_api.mandatory_arg_error(p_api_name => g_package
1692: ,p_argument => 'p_effective_date'
1693: ,p_argument_value => p_effective_date );
1694: --
1695: -- Get chunk_size and Thread values for multi-thread process, and check to