APPS.GHR_ELEMENT_API dependencies on GHR_PA_REQUESTS

Line 210: From ghr_pa_requests

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

Line 852: From ghr_pa_requests

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

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

1534: l_noa_code := noa_code_rec.code;
1535: end loop;
1536: -- Bug 3854447
1537: -- Get the NOA_FAMILCY_CODE by calling the function
1538: l_noa_fam_code := ghr_pa_requests_pkg.get_noa_pm_family(l_noa_id);
1539: --
1540: hr_utility.set_location('l_noa_id is ' || l_noa_id,2);
1541: hr_utility.set_location('l_noa_code is ' || l_noa_code,2);
1542: hr_utility.set_location('l_noa_fam_code is ' || l_noa_fam_code,2);