APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 1201: FROM ghr_pa_request_extra_info rei

1197: l_organization_id VARCHAR2(150);
1198:
1199: CURSOR cur_rei_org IS
1200: SELECT rei.rei_information8 org_id -- Bug 2681726 Changed information9 to 8 as we need to consider position's org
1201: FROM ghr_pa_request_extra_info rei
1202: WHERE pa_request_id = p_pa_request_id
1203: AND rei.information_type = 'GHR_US_PAR_REALIGNMENT';
1204:
1205: CURSOR cur_org (p_org_id number) IS

Line 2231: FROM ghr_pa_request_extra_info

2227: WHERE pa_request_id = p_pa_request_id;
2228:
2229: CURSOR cur_temp_step IS
2230: SELECT rei_information3 temp_step
2231: FROM ghr_pa_request_extra_info
2232: WHERE pa_request_id = p_pa_request_id
2233: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
2234:
2235: BEGIN