DBA Data[Home] [Help]

APPS.GHR_ELEMENT_API dependencies on GHR_PA_REQUESTS

Line 212: From ghr_pa_requests

208: --
209: -- to pick pay basis from PAR
210: Cursor Cur_pay_basis is
211: Select from_pay_basis,to_pay_basis
212: From ghr_pa_requests
213: Where pa_request_id=l_session.pa_request_id;
214: -- Where employee_assignment_id=p_assignment_id;
215: -- and effective_date=p_eff_date;
216: ll_bg_id NUMBER;

Line 854: From ghr_pa_requests

850: --
851: -- to pick pay basis from PAR
852: Cursor Cur_pay_basis is
853: Select from_pay_basis,to_pay_basis
854: From ghr_pa_requests
855: Where pa_request_id=l_session.pa_request_id;
856: -- Where employee_assignment_id=p_assignment_id;
857: -- and effective_date=p_eff_date;
858: --

Line 1565: l_noa_fam_code := ghr_pa_requests_pkg.get_noa_pm_family(l_noa_id);

1561: l_noa_code := noa_code_rec.code;
1562: end loop;
1563: -- Bug 3854447
1564: -- Get the NOA_FAMILCY_CODE by calling the function
1565: l_noa_fam_code := ghr_pa_requests_pkg.get_noa_pm_family(l_noa_id);
1566: --
1567: hr_utility.set_location('l_noa_id is ' || l_noa_id,2);
1568: hr_utility.set_location('l_noa_code is ' || l_noa_code,2);
1569: hr_utility.set_location('l_noa_fam_code is ' || l_noa_fam_code,2);