APPS.BEN_PRTT_RMT_APRVD_PYMT_API dependencies on BEN_ACTY_BASE_RT_F

Line 115: from ben_acty_base_rt_f abr

111: abr.comp_lvl_fctr_id,
112: abr.actl_prem_id,
113: abr.input_value_id,
114: abr.element_type_id
115: from ben_acty_base_rt_f abr
116: where pl_id = p_pl_id
117: and acty_typ_cd like 'PRD%'
118: and acty_base_rt_stat_cd = 'A'
119: and p_effective_date between

Line 137: from ben_acty_base_rt_f abr,

133: abr.comp_lvl_fctr_id,
134: abr.actl_prem_id,
135: abr.input_value_id,
136: abr.element_type_id
137: from ben_acty_base_rt_f abr,
138: ben_plip_f plp
139: where plp.pl_id = p_pl_id
140: and plp.pgm_id = p_pgm_id
141: and p_effective_date between

Line 600: from ben_acty_base_rt_f abr

596: cursor c_acty_base_rt (p_acty_base_rt number)
597: is
598: select abr.input_value_id,
599: abr.element_type_id
600: from ben_acty_base_rt_f abr
601: where acty_base_rt_id = p_acty_base_rt
602: and p_effective_date between
603: abr.effective_start_date and
604: abr.effective_end_date;

Line 629: from ben_acty_base_rt_f abr

625: abr.comp_lvl_fctr_id,
626: abr.actl_prem_id,
627: abr.input_value_id,
628: abr.element_type_id
629: from ben_acty_base_rt_f abr
630: where pl_id = p_pl_id
631: and acty_typ_cd like 'PRD%'
632: and acty_base_rt_stat_cd = 'A'
633: and p_effective_date between

Line 651: from ben_acty_base_rt_f abr,

647: abr.comp_lvl_fctr_id,
648: abr.actl_prem_id,
649: abr.input_value_id,
650: abr.element_type_id
651: from ben_acty_base_rt_f abr,
652: ben_plip_f plp
653: where plp.pl_id = p_pl_id
654: and plp.pgm_id = p_pgm_id
655: and p_effective_date between

Line 678: l_input_value_id ben_acty_base_rt_f.input_value_id%type;

674:
675:
676:
677: --
678: l_input_value_id ben_acty_base_rt_f.input_value_id%type;
679: l_element_type_id ben_acty_base_rt_f.element_type_id%type ;
680: l_proc varchar2(72) := g_package||'update_prtt_rmt_aprvd_pymt';
681: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
682: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;

Line 679: l_element_type_id ben_acty_base_rt_f.element_type_id%type ;

675:
676:
677: --
678: l_input_value_id ben_acty_base_rt_f.input_value_id%type;
679: l_element_type_id ben_acty_base_rt_f.element_type_id%type ;
680: l_proc varchar2(72) := g_package||'update_prtt_rmt_aprvd_pymt';
681: l_object_version_number ben_prtt_rmt_aprvd_fr_pymt_f.object_version_number%TYPE;
682: l_effective_start_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_start_date%TYPE;
683: l_effective_end_date ben_prtt_rmt_aprvd_fr_pymt_f.effective_end_date%TYPE;