APPS.PQH_RBC_STAGE_TO_RBC dependencies on BEN_PL_F

Line 672: p_pl_id out nocopy ben_pl_f.pl_id%type,

668:
669: procedure get_plan_det_for_rmn(p_rmn_id in number,
670: p_business_group_id in number,
671: p_effective_date in date,
672: p_pl_id out nocopy ben_pl_f.pl_id%type,
673: p_pl_name out nocopy ben_pl_f.name%type)
674: is
675: begin
676: hr_utility.set_location('Entering get_plan_name_for_rmn ',100);

Line 673: p_pl_name out nocopy ben_pl_f.name%type)

669: procedure get_plan_det_for_rmn(p_rmn_id in number,
670: p_business_group_id in number,
671: p_effective_date in date,
672: p_pl_id out nocopy ben_pl_f.pl_id%type,
673: p_pl_name out nocopy ben_pl_f.name%type)
674: is
675: begin
676: hr_utility.set_location('Entering get_plan_name_for_rmn ',100);
677:

Line 680: from ben_pl_f pl,

676: hr_utility.set_location('Entering get_plan_name_for_rmn ',100);
677:
678: select pl.pl_id pl_id, pl.name pl_name
679: into p_pl_id, p_pl_name
680: from ben_pl_f pl,
681: pqh_rate_matrix_nodes rmn
682: where rmn.pl_id = pl.pl_id
683: and p_effective_date between pl.effective_start_date and pl.effective_end_date
684: and rmn.rate_matrix_node_id = p_rmn_id

Line 760: l_pl_name ben_pl_f.name%type;

756: l_esd date;
757: l_esd_abr date;
758: l_eed_abr date;
759: l_abr_id number;
760: l_pl_name ben_pl_f.name%type;
761: l_pl_id ben_pl_f.pl_id%type;
762: l_crd_name pqh_criteria_rate_defn_vl.name%type;
763: l_ovn_abr number;
764: l_short_code_rmn varchar2(1000);

Line 761: l_pl_id ben_pl_f.pl_id%type;

757: l_esd_abr date;
758: l_eed_abr date;
759: l_abr_id number;
760: l_pl_name ben_pl_f.name%type;
761: l_pl_id ben_pl_f.pl_id%type;
762: l_crd_name pqh_criteria_rate_defn_vl.name%type;
763: l_ovn_abr number;
764: l_short_code_rmn varchar2(1000);
765: l_base_rt_exist varchar2(1);

Line 787: from ben_pl_f pl, pqh_rate_matrix_nodes rmn

783: hr_utility.set_location('rmr id'||l_rmr_id,20);
784:
785: select min(effective_start_date)
786: into l_esd
787: from ben_pl_f pl, pqh_rate_matrix_nodes rmn
788: where rmn.pl_id = pl.pl_id
789: and rmn.rate_matrix_node_id = p_rmn_id;
790:
791: if l_esd < p_effective_date then

Line 1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',

1094: and l_plan_id is not null then
1095: hr_utility.set_location('Plan is being updated'||l_plan_id,60);
1096: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
1097: if p_datetrack_mode <> 'CORRECTION' then
1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',
1099: p_key_column_name => 'PL_ID',
1100: p_key_column_value => l_plan_id,
1101: p_effective_date => p_effective_date);
1102: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 1106: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PL_F',

1102: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1103: else
1104: l_dt_mode := p_datetrack_mode;
1105: end if;
1106: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PL_F',
1107: p_key_column_name => 'PL_ID',
1108: p_key_column_value => l_plan_id,
1109: p_effective_date => p_effective_date);
1110: hr_utility.set_location(' ovn is '||l_db_ovn,30);