APPS.PQH_GSP_UTILITY dependencies on BEN_PGM_EXTRA_INFO

Line 4137: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4135: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4136: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4137: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
4138:
4139: Begin
4140:
4141: if g_debug then

Line 5761: FROM ben_pgm_extra_info

5757: return varchar2
5758: IS
5759: Cursor csr_gl_ann_factor IS
5760: SELECT pgi_information5 rate_ann_factor
5761: FROM ben_pgm_extra_info
5762: WHERE pgm_id = p_pgm_id
5763: AND information_type = 'PQH_GSP_EXTRA_INFO';
5764: l_proc constant varchar2(72):= g_package||'get_gl_ann_factor';
5765: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

Line 5765: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

5761: FROM ben_pgm_extra_info
5762: WHERE pgm_id = p_pgm_id
5763: AND information_type = 'PQH_GSP_EXTRA_INFO';
5764: l_proc constant varchar2(72):= g_package||'get_gl_ann_factor';
5765: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
5766: BEGIN
5767: hr_utility.set_location('Entering:'||l_proc, 5);
5768: open csr_gl_ann_factor;
5769: FETCH csr_gl_ann_factor INTO l_gl_ann_factor;