eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 317: l_detail_type ghr_pa_request_extra_info.rei_information3%type;

313:
314: l_occ_code ghr_pa_requests.from_occ_code%TYPE;
315:
316: --Begin Bug# 8653508
317: l_detail_type ghr_pa_request_extra_info.rei_information3%type;
318: l_unclassified_duty_ind ghr_pa_request_extra_info.rei_information4%type;
319: l_detail_position_id ghr_pa_request_extra_info.rei_information5%type;--bug# 11781477
320:
321: CURSOR cur_detail_info IS

Line 318: l_unclassified_duty_ind ghr_pa_request_extra_info.rei_information4%type;

314: l_occ_code ghr_pa_requests.from_occ_code%TYPE;
315:
316: --Begin Bug# 8653508
317: l_detail_type ghr_pa_request_extra_info.rei_information3%type;
318: l_unclassified_duty_ind ghr_pa_request_extra_info.rei_information4%type;
319: l_detail_position_id ghr_pa_request_extra_info.rei_information5%type;--bug# 11781477
320:
321: CURSOR cur_detail_info IS
322: SELECT rei_information3 ,

Line 319: l_detail_position_id ghr_pa_request_extra_info.rei_information5%type;--bug# 11781477

315:
316: --Begin Bug# 8653508
317: l_detail_type ghr_pa_request_extra_info.rei_information3%type;
318: l_unclassified_duty_ind ghr_pa_request_extra_info.rei_information4%type;
319: l_detail_position_id ghr_pa_request_extra_info.rei_information5%type;--bug# 11781477
320:
321: CURSOR cur_detail_info IS
322: SELECT rei_information3 ,
323: rei_information4 ,

Line 325: FROM ghr_pa_request_extra_info

321: CURSOR cur_detail_info IS
322: SELECT rei_information3 ,
323: rei_information4 ,
324: rei_information5 --bug# 11781477
325: FROM ghr_pa_request_extra_info
326: WHERE pa_request_id = p_pa_request_rec.pa_request_id
327: AND information_type = 'GHR_US_PAR_DET_INFO';
328:
329: CURSOR cur_detail_exists(p_asg_id per_assignments_f.assignment_id%TYPE,

Line 377: FROM ghr_pa_request_extra_info

373: --
374: CURSOR cur_repay_sch IS
375: SELECT rei_information8 repay_sch,
376: rei_information9 review_Date
377: FROM ghr_pa_request_extra_info
378: WHERE pa_request_id = p_pa_request_rec.pa_request_id
379: AND information_type = 'GHR_US_PAR_STUDENT_LOAN';
380:
381: l_repay_sch varchar2(2);

Line 528: FROM ghr_pa_request_extra_info

524: CURSOR cur_service_oblg_ei IS
525: SELECT rei_information3 srvc_oblg_type,
526: rei_information4 srvc_oblg_st_date,
527: rei_information5 srvc_oblg_end_date
528: FROM ghr_pa_request_extra_info
529: WHERE pa_request_id = p_pa_request_rec.pa_request_id AND
530: information_type = 'GHR_US_PAR_SERVICE_OBLIGATION';
531: /* Bug#5132121 Service Obligation for Student Loan and MD/DDS */
532:

Line 542: FROM ghr_pa_request_extra_info

538: --8528195
539: --Begin Bug# 12557463
540: CURSOR c_get_tsp_scd IS
541: SELECT rei_information6 tsp_scd
542: FROM ghr_pa_request_extra_info
543: WHERE pa_request_id = p_pa_request_rec.pa_request_id
544: AND information_type = 'GHR_US_PAR_SCD_INFO';
545: l_tsp_scd ghr_pa_request_extra_info.rei_information6%type;
546: --End Bug# 12557463

Line 545: l_tsp_scd ghr_pa_request_extra_info.rei_information6%type;

541: SELECT rei_information6 tsp_scd
542: FROM ghr_pa_request_extra_info
543: WHERE pa_request_id = p_pa_request_rec.pa_request_id
544: AND information_type = 'GHR_US_PAR_SCD_INFO';
545: l_tsp_scd ghr_pa_request_extra_info.rei_information6%type;
546: --End Bug# 12557463
547: --Begin Bug# 14769681
548: CURSOR c_get_tsp_scd_803 IS
549: SELECT rei_information7 tsp_scd

Line 550: FROM ghr_pa_request_extra_info

546: --End Bug# 12557463
547: --Begin Bug# 14769681
548: CURSOR c_get_tsp_scd_803 IS
549: SELECT rei_information7 tsp_scd
550: FROM ghr_pa_request_extra_info
551: WHERE pa_request_id = p_pa_request_rec.pa_request_id
552: AND information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN';
553: --End Bug# 14769681
554:

Line 556: l_fehb_elig_exp_date ghr_pa_request_extra_info.rei_information4%type;

552: AND information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN';
553: --End Bug# 14769681
554:
555: --Begin Bug# 12637350
556: l_fehb_elig_exp_date ghr_pa_request_extra_info.rei_information4%type;
557: l_noa_nte_date date;
558: CURSOR cur_fehb_elg_exp_date IS
559: SELECT rei_information3
560: FROM ghr_pa_request_extra_info

Line 560: FROM ghr_pa_request_extra_info

556: l_fehb_elig_exp_date ghr_pa_request_extra_info.rei_information4%type;
557: l_noa_nte_date date;
558: CURSOR cur_fehb_elg_exp_date IS
559: SELECT rei_information3
560: FROM ghr_pa_request_extra_info
561: WHERE pa_request_id = p_pa_request_rec.pa_request_id
562: AND information_type = 'GHR_US_PAR_BENEFITS';
563:
564: cursor cur_asg_prior_date is