APPS.BEN_PRTL_MO_RT_PRTN_VAL_API dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 67: l_prtl_mo_rt_prtn_val_id ben_prtl_mo_rt_prtn_val_f.prtl_mo_rt_prtn_val_id%TYPE;

63: ) is
64: --
65: -- Declare cursors and local variables
66: --
67: l_prtl_mo_rt_prtn_val_id ben_prtl_mo_rt_prtn_val_f.prtl_mo_rt_prtn_val_id%TYPE;
68: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
69: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Prtl_Mo_Rt_Prtn_Val';
71: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;

Line 68: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;

64: --
65: -- Declare cursors and local variables
66: --
67: l_prtl_mo_rt_prtn_val_id ben_prtl_mo_rt_prtn_val_f.prtl_mo_rt_prtn_val_id%TYPE;
68: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
69: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Prtl_Mo_Rt_Prtn_Val';
71: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
72: --

Line 69: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;

65: -- Declare cursors and local variables
66: --
67: l_prtl_mo_rt_prtn_val_id ben_prtl_mo_rt_prtn_val_f.prtl_mo_rt_prtn_val_id%TYPE;
68: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
69: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Prtl_Mo_Rt_Prtn_Val';
71: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
72: --
73: begin

Line 71: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;

67: l_prtl_mo_rt_prtn_val_id ben_prtl_mo_rt_prtn_val_f.prtl_mo_rt_prtn_val_id%TYPE;
68: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
69: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Prtl_Mo_Rt_Prtn_Val';
71: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
72: --
73: begin
74: --
75: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 374: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;

370: --
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_Prtl_Mo_Rt_Prtn_Val';
374: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
375: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
376: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
377: --
378: begin

Line 375: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;

371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_Prtl_Mo_Rt_Prtn_Val';
374: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
375: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
376: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
377: --
378: begin
379: --

Line 376: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;

372: --
373: l_proc varchar2(72) := g_package||'update_Prtl_Mo_Rt_Prtn_Val';
374: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
375: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
376: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
377: --
378: begin
379: --
380: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 636: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;

632: --
633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_Prtl_Mo_Rt_Prtn_Val';
636: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
637: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
638: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
639: --
640: begin

Line 637: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;

633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_Prtl_Mo_Rt_Prtn_Val';
636: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
637: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
638: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
639: --
640: begin
641: --

Line 638: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;

634: --
635: l_proc varchar2(72) := g_package||'update_Prtl_Mo_Rt_Prtn_Val';
636: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
637: l_effective_end_date ben_prtl_mo_rt_prtn_val_f.effective_end_date%TYPE;
638: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 794: from ben_Prtl_Mo_Rt_Prtn_Val_f ppv

790: ) is
791: --
792: cursor c_ppv is
793: select distinct prtl_mo_rt_prtn_val_id
794: from ben_Prtl_Mo_Rt_Prtn_Val_f ppv
795: where (ppv.acty_base_rt_id = p_acty_base_rt_id or
796: ppv.actl_prem_id = p_actl_prem_id)
797: and ppv.prorate_by_day_to_mon_flag = 'N'
798: and p_effective_date between ppv.effective_start_date

Line 803: from ben_Prtl_Mo_Rt_Prtn_Val_f ppv

799: and ppv.effective_end_date;
800: --
801: cursor c_ppv2 (p_prtl_mo_rt_prtn_val_id number) is
802: select *
803: from ben_Prtl_Mo_Rt_Prtn_Val_f ppv
804: where ppv.prtl_mo_rt_prtn_val_id = p_prtl_mo_rt_prtn_val_id
805: and p_effective_date between ppv.effective_start_date
806: and ppv.effective_end_date
807: order by ppv.effective_start_date;