APPS.PQH_GSP_UTILITY dependencies on BEN_PGM_EXTRA_INFO

Line 4018: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
4016: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
4017: l_pay_basis Per_Pay_Bases.Pay_basis%TYPE;
4018: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
4019:
4020: Begin
4021:
4022: if g_debug then

Line 5642: FROM ben_pgm_extra_info

5638: return varchar2
5639: IS
5640: Cursor csr_gl_ann_factor IS
5641: SELECT pgi_information5 rate_ann_factor
5642: FROM ben_pgm_extra_info
5643: WHERE pgm_id = p_pgm_id
5644: AND information_type = 'PQH_GSP_EXTRA_INFO';
5645: l_proc constant varchar2(72):= g_package||'get_gl_ann_factor';
5646: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

Line 5646: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;

5642: FROM ben_pgm_extra_info
5643: WHERE pgm_id = p_pgm_id
5644: AND information_type = 'PQH_GSP_EXTRA_INFO';
5645: l_proc constant varchar2(72):= g_package||'get_gl_ann_factor';
5646: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
5647: BEGIN
5648: hr_utility.set_location('Entering:'||l_proc, 5);
5649: open csr_gl_ann_factor;
5650: FETCH csr_gl_ann_factor INTO l_gl_ann_factor;