DBA Data[Home] [Help]

APPS.PQH_RBC_LOAD_OBJECTS dependencies on BEN_ACTY_BASE_RT_F

Line 530: l_abr ben_acty_base_rt_f.acty_base_rt_id%type;

526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;
530: l_abr ben_acty_base_rt_f.acty_base_rt_id%type;
531: l_ovn number := 1;
532: l_effective_start_date date ;
533: l_effective_end_date date ;
534: l_effective_date date;

Line 571: From ben_acty_base_rt_f

567: -- rate matrix.
568: --
569: Cursor csr_abr is
570: select acty_base_rt_id
571: From ben_acty_base_rt_f
572: Where acty_typ_cd = 'RBC'
573: and l_effective_date between effective_start_date and effective_end_date
574: and business_group_id = l_business_group_id
575: and pl_id = l_pl_id