APPS.GHR_VALIDATE_CHECK dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 84: l_mddds_pay_nte_date_old ghr_pa_request_extra_info.rei_information12%TYPE;

80: --Pradeep
81: l_mddds_special_pay_amount number;
82: l_mddds_specia_pay_nte_date date;
83: l_mddds_pay_amount_old number;
84: l_mddds_pay_nte_date_old ghr_pa_request_extra_info.rei_information12%TYPE;
85:
86: l_premium_pay_ind VARCHAR2(30);
87: l_hz_ind VARCHAR2(30);
88: l_edp_ind VARCHAR2(30);

Line 201: FROM ghr_pa_request_extra_info

197: and nvl(nla.date_to,nvl(p_pa_request_rec.effective_date,trunc(sysdate)));
198: --end Bug# 7501214
199: CURSOR cur_temp_step IS
200: SELECT rei_information3 temp_step
201: FROM ghr_pa_request_extra_info
202: WHERE pa_request_id = p_pa_request_rec.pa_request_id
203: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
204: l_temp_step per_people_extra_info.pei_information9%type := hr_api.g_varchar2;
205:

Line 292: FROM ghr_pa_request_extra_info

288: SELECT NVL(rei_information3,0)+NVL(rei_information4,0)+NVL(rei_information5,0)+NVL(rei_information6,0)
289: +NVL(rei_information7,0)+NVL(rei_information8,0)+NVL(rei_information9,0)+NVL(rei_information10,0) amount,
290: rei_information12 nte_date,rei_information13 premium_pay_ind
291:
292: FROM ghr_pa_request_extra_info
293: WHERE pa_request_id = p_pa_request_rec.pa_request_id
294: AND information_type = 'GHR_US_PAR_MD_DDS_PAY';
295:
296: CURSOR cur_premium_pay IS

Line 298: FROM ghr_pa_request_extra_info

294: AND information_type = 'GHR_US_PAR_MD_DDS_PAY';
295:
296: CURSOR cur_premium_pay IS
297: SELECT NVL(rei_information3,0) premium_pay_ind
298: FROM ghr_pa_request_extra_info
299: WHERE pa_request_id = p_pa_request_rec.pa_request_id
300: AND information_type = 'GHR_US_PAR_PREMIUM_PAY';
301:
302:

Line 305: FROM ghr_pa_request_extra_info

301:
302:
303: CURSOR cur_premium_pay_ind IS
304: SELECT NVL(rei_information3,0) premium_pay_ind
305: FROM ghr_pa_request_extra_info
306: WHERE pa_request_id = p_pa_request_rec.pa_request_id
307: AND information_type = 'GHR_US_PAR_PREMIUM_PAY_IND';
308:
309: CURSOR cur_job_code is

Line 321: FROM ghr_pa_request_extra_info

317: --
318: CURSOR cur_repay_sch IS
319: SELECT rei_information8 repay_sch,
320: rei_information9 review_Date
321: FROM ghr_pa_request_extra_info
322: WHERE pa_request_id = p_pa_request_rec.pa_request_id
323: AND information_type = 'GHR_US_PAR_STUDENT_LOAN';
324:
325: l_repay_sch varchar2(2);

Line 472: FROM ghr_pa_request_extra_info

468: CURSOR cur_service_oblg_ei IS
469: SELECT rei_information3 srvc_oblg_type,
470: rei_information4 srvc_oblg_st_date,
471: rei_information5 srvc_oblg_end_date
472: FROM ghr_pa_request_extra_info
473: WHERE pa_request_id = p_pa_request_rec.pa_request_id AND
474: information_type = 'GHR_US_PAR_SERVICE_OBLIGATION';
475: /* Bug#5132121 Service Obligation for Student Loan and MD/DDS */
476: