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_SF52_DO_UPDATE dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 645: from ghr_pa_request_extra_info rei,

641: --
642: cursor c_702_rec is
643: select rei_information3,pei_information1,
644: pei.object_version_number ovn
645: from ghr_pa_request_extra_info rei,
646: per_people_extra_info pei
647: where pa_request_id = p_pa_request_rec.pa_request_id
648: and pei.person_extra_info_id = rei.rei_information3
649: and pei.information_type = 'GHR_US_RETAINED_GRADE'

Line 656: from ghr_pa_request_extra_info rei,

652: --
653: cursor c_740_rec is
654: select rei_information3,pei_information1,
655: pei.object_version_number ovn
656: from ghr_pa_request_extra_info rei,
657: per_people_extra_info pei
658: where pa_request_id = p_pa_request_rec.pa_request_id
659: and pei.person_extra_info_id = rei.rei_information3
660: and pei.information_type = 'GHR_US_RETAINED_GRADE'

Line 687: FROM ghr_pa_request_extra_info

683:
684: CURSOR cur_temp_step
685: IS
686: SELECT rei_information3 temp_step
687: FROM ghr_pa_request_extra_info
688: WHERE pa_request_id = p_pa_request_rec.pa_request_id
689: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
690:
691: l_session ghr_history_api.g_session_var_type;

Line 1434: FROM ghr_pa_request_extra_info

1430: -- for bug 3191704
1431: CURSOR cur_rei_poi(p_par_id in NUMBER)
1432: IS
1433: SELECT rei_information5
1434: FROM ghr_pa_request_extra_info
1435: WHERE pa_request_id=p_par_id
1436: AND information_type='GHR_US_PAR_REALIGNMENT';
1437:
1438: target_poi ghr_pa_requests.personnel_office_id%type;

Line 2562: FROM ghr_pa_request_extra_info

2558: --Begin Bug# 8724192
2559: l_appointment_type varchar2(10);
2560: CURSOR cur_get_app_type IS
2561: SELECT rei_information4 appointment_type
2562: FROM ghr_pa_request_extra_info
2563: WHERE rei_information_category='GHR_US_PAR_APPT_TRANSFER'
2564: AND pa_request_id = p_pa_request_id;
2565: --End Bug# 8724192
2566:

Line 3420: from ghr_pa_request_extra_info

3416: -- payroll id
3417:
3418: Cursor c_payroll_name is
3419: select rei_information3 payroll_id
3420: from ghr_pa_request_extra_info
3421: where pa_request_id = p_pa_request_rec.pa_request_id
3422: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
3423:
3424: Cursor c_payroll_id is

Line 3661: FROM ghr_pa_request_extra_info

3657:
3658: --Pradeep
3659: CURSOR cur_get_nte_date IS
3660: SELECT rei_information12 nte_date, rei_information11 amount
3661: FROM ghr_pa_request_extra_info
3662: WHERE rei_information_category='GHR_US_PAR_MD_DDS_PAY'
3663: AND pa_request_id = p_pa_request_rec.pa_request_id;
3664:
3665: CURSOR check_remarks is

Line 3681: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;

3677: and rem.enabled_flag = 'Y'
3678: and nvl(p_pa_request_rec.effective_date,sysdate)
3679: between rem.date_from and nvl(rem.date_to,nvl(p_pa_request_rec.effective_date, trunc(sysdate)));
3680:
3681: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3682: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3683: l_check_remarks BOOLEAN := FALSE;
3684: l_rpa_remark_code ghr_remarks.code%TYPE;
3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;

Line 3682: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;

3678: and nvl(p_pa_request_rec.effective_date,sysdate)
3679: between rem.date_from and nvl(rem.date_to,nvl(p_pa_request_rec.effective_date, trunc(sysdate)));
3680:
3681: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3682: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3683: l_check_remarks BOOLEAN := FALSE;
3684: l_rpa_remark_code ghr_remarks.code%TYPE;
3685: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3686:

Line 5092: FROM ghr_pa_request_extra_info

5088:
5089: CURSOR cur_temp_step
5090: IS
5091: SELECT rei_information3 temp_step
5092: FROM ghr_pa_request_extra_info
5093: WHERE pa_request_id = p_pa_request_rec.pa_request_id
5094: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
5095:
5096: -- Start of code for Payroll Integration

Line 5221: FROM ghr_pa_request_extra_info

5217: -- Bug 3263140
5218: CURSOR cur_wgi_due
5219: IS
5220: SELECT rei_information4 wgi_due
5221: FROM ghr_pa_request_extra_info
5222: WHERE pa_request_id = p_pa_request_rec.pa_request_id
5223: AND information_type = 'GHR_US_PAR_SALARY_CHG';
5224: --
5225: -- Bug 3953455 Cursor to fetch the To step for both normal and correction actions.

Line 8174: from ghr_pa_request_extra_info

8170: l_lei_date varchar2(60); -- Bug 3709414
8171:
8172: Cursor c_payroll is
8173: select rei_information3 payroll_type
8174: from ghr_pa_request_extra_info
8175: where pa_request_id = p_pa_request_rec.pa_request_id
8176: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
8177:
8178: Cursor c_payroll_id is