APPS.PQH_GSP_UTILITY dependencies on PAY_RATES

Line 145: pay_rates pr,

141: BEN_PL_TYP_F bpt,
142: ben_plip_f bplip,
143: per_grade_spines_f pgs,
144: per_grades pg,
145: pay_rates pr,
146: per_parent_spines pps
147: where
148: bp.pl_typ_id = bpt.pl_typ_id
149: and bpt.OPT_TYP_CD = 'GSP'

Line 3124: ,p_Use_multi_pay_rates_flag in Varchar2

3120: ,p_Use_prog_points_flag in Varchar2
3121: ,p_Dflt_step_cd in Varchar2
3122: ,p_Dflt_step_rl in number
3123: ,p_Update_salary_cd in Varchar2
3124: ,p_Use_multi_pay_rates_flag in Varchar2
3125: ,p_dflt_element_type_id in number
3126: ,p_Dflt_input_value_id in number
3127: ,p_Use_scores_cd in Varchar2
3128: ,p_Scores_calc_mthd_cd in Varchar2

Line 3909: l_rate_id pay_rates.rate_id%type;

3905: is
3906: --
3907: -- Local variables
3908: --
3909: l_rate_id pay_rates.rate_id%type;
3910: l_ovn pay_rates.object_version_number%type;
3911: l_proc varchar2(100) := 'pqh_gsp_utility.create_pay_rate';
3912: --
3913: Begin

Line 3910: l_ovn pay_rates.object_version_number%type;

3906: --
3907: -- Local variables
3908: --
3909: l_rate_id pay_rates.rate_id%type;
3910: l_ovn pay_rates.object_version_number%type;
3911: l_proc varchar2(100) := 'pqh_gsp_utility.create_pay_rate';
3912: --
3913: Begin
3914: --

Line 3950: l_rate_id pay_rates.rate_id%type;

3946: is
3947: --
3948: -- Local variables
3949: --
3950: l_rate_id pay_rates.rate_id%type;
3951: l_ovn pay_rates.object_version_number%type;
3952: l_proc varchar2(100) := 'pqh_gsp_utility.create_pay_rate';
3953: --
3954: Begin

Line 3951: l_ovn pay_rates.object_version_number%type;

3947: --
3948: -- Local variables
3949: --
3950: l_rate_id pay_rates.rate_id%type;
3951: l_ovn pay_rates.object_version_number%type;
3952: l_proc varchar2(100) := 'pqh_gsp_utility.create_pay_rate';
3953: --
3954: Begin
3955: --