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 630: from ghr_pa_request_extra_info rei,

626: --
627: cursor c_702_rec is
628: select rei_information3,pei_information1,
629: pei.object_version_number ovn
630: from ghr_pa_request_extra_info rei,
631: per_people_extra_info pei
632: where pa_request_id = p_pa_request_rec.pa_request_id
633: and pei.person_extra_info_id = rei.rei_information3
634: and pei.information_type = 'GHR_US_RETAINED_GRADE'

Line 641: from ghr_pa_request_extra_info rei,

637: --
638: cursor c_740_rec is
639: select rei_information3,pei_information1,
640: pei.object_version_number ovn
641: from ghr_pa_request_extra_info rei,
642: per_people_extra_info pei
643: where pa_request_id = p_pa_request_rec.pa_request_id
644: and pei.person_extra_info_id = rei.rei_information3
645: and pei.information_type = 'GHR_US_RETAINED_GRADE'

Line 672: FROM ghr_pa_request_extra_info

668:
669: CURSOR cur_temp_step
670: IS
671: SELECT rei_information3 temp_step
672: FROM ghr_pa_request_extra_info
673: WHERE pa_request_id = p_pa_request_rec.pa_request_id
674: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
675:
676: l_session ghr_history_api.g_session_var_type;

Line 1418: FROM ghr_pa_request_extra_info

1414: -- for bug 3191704
1415: CURSOR cur_rei_poi(p_par_id in NUMBER)
1416: IS
1417: SELECT rei_information5
1418: FROM ghr_pa_request_extra_info
1419: WHERE pa_request_id=p_par_id
1420: AND information_type='GHR_US_PAR_REALIGNMENT';
1421:
1422: target_poi ghr_pa_requests.personnel_office_id%type;

Line 3215: from ghr_pa_request_extra_info

3211: -- payroll id
3212:
3213: Cursor c_payroll_name is
3214: select rei_information3 payroll_id
3215: from ghr_pa_request_extra_info
3216: where pa_request_id = p_pa_request_rec.pa_request_id
3217: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
3218:
3219: Cursor c_payroll_id is

Line 3441: FROM ghr_pa_request_extra_info

3437:
3438: --Pradeep
3439: CURSOR cur_get_nte_date IS
3440: SELECT rei_information12 nte_date, rei_information11 amount
3441: FROM ghr_pa_request_extra_info
3442: WHERE rei_information_category='GHR_US_PAR_MD_DDS_PAY'
3443: AND pa_request_id = p_pa_request_rec.pa_request_id;
3444:
3445: CURSOR check_remarks is

Line 3464: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;

3460: and rem.enabled_flag = 'Y'
3461: and nvl(p_pa_request_rec.effective_date,sysdate)
3462: between rem.date_from and nvl(rem.date_to,nvl(p_pa_request_rec.effective_date, trunc(sysdate)));
3463:
3464: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3465: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3466: l_check_remarks BOOLEAN := FALSE;
3467: l_rpa_remark_code ghr_remarks.code%TYPE;
3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;

Line 3465: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;

3461: and nvl(p_pa_request_rec.effective_date,sysdate)
3462: between rem.date_from and nvl(rem.date_to,nvl(p_pa_request_rec.effective_date, trunc(sysdate)));
3463:
3464: l_mddds_special_pay_nte_date ghr_pa_request_extra_info.rei_information12%TYPE;
3465: l_mddds_total_special_pay ghr_pa_request_extra_info.rei_information11%TYPE;
3466: l_check_remarks BOOLEAN := FALSE;
3467: l_rpa_remark_code ghr_remarks.code%TYPE;
3468: l_rpa_remark_id ghr_remarks.remark_id%TYPE;
3469:

Line 4833: FROM ghr_pa_request_extra_info

4829:
4830: CURSOR cur_temp_step
4831: IS
4832: SELECT rei_information3 temp_step
4833: FROM ghr_pa_request_extra_info
4834: WHERE pa_request_id = p_pa_request_rec.pa_request_id
4835: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
4836:
4837: -- Start of code for Payroll Integration

Line 4962: FROM ghr_pa_request_extra_info

4958: -- Bug 3263140
4959: CURSOR cur_wgi_due
4960: IS
4961: SELECT rei_information4 wgi_due
4962: FROM ghr_pa_request_extra_info
4963: WHERE pa_request_id = p_pa_request_rec.pa_request_id
4964: AND information_type = 'GHR_US_PAR_SALARY_CHG';
4965: --
4966: -- Bug 3953455 Cursor to fetch the To step for both normal and correction actions.

Line 7871: from ghr_pa_request_extra_info

7867: l_lei_date varchar2(60); -- Bug 3709414
7868:
7869: Cursor c_payroll is
7870: select rei_information3 payroll_type
7871: from ghr_pa_request_extra_info
7872: where pa_request_id = p_pa_request_rec.pa_request_id
7873: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
7874:
7875: Cursor c_payroll_id is