APPS.GHR_PC_BASIC_PAY dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 31: FROM ghr_pa_request_extra_info

27: WHERE pa_request_id = p_pa_request_id;
28:
29: CURSOR cur_temp_step IS
30: SELECT rei_information3 temp_step
31: FROM ghr_pa_request_extra_info
32: WHERE pa_request_id = p_pa_request_id
33: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
34:
35: --

Line 63: FROM ghr_pa_request_extra_info

59: AND p_effective_date
60: BETWEEN NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date)
61: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date)
62: AND pei2.person_extra_info_id NOT IN (SELECT rei_information3
63: FROM ghr_pa_request_extra_info
64: WHERE pa_request_id = p_pa_request_id
65: AND (rei_information5 is null OR rei_information5 = 'Y')
66: AND information_type in ('GHR_US_PAR_TERM_RET_GRADE',
67: 'GHR_US_PAR_TERM_RG_PROMO',

Line 72: FROM ghr_pa_request_extra_info

68: 'GHR_US_PAR_TERM_RG_POSN_CHG')
69: )
70: )
71: AND pei.person_extra_info_id NOT IN (SELECT rei_information3
72: FROM ghr_pa_request_extra_info
73: WHERE pa_request_id = p_pa_request_id
74: AND information_type in ( 'GHR_US_PAR_TERM_RET_GRADE',
75: 'GHR_US_PAR_TERM_RG_PROMO',
76: 'GHR_US_PAR_TERM_RG_POSN_CHG')

Line 235: FROM ghr_pa_request_extra_info

231: WHERE pei2.person_id = p_person_id
232: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
233: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date
234: AND pei2.person_extra_info_id NOT IN (SELECT rei_information3
235: FROM ghr_pa_request_extra_info
236: WHERE pa_request_id = p_pa_request_id
237: AND (rei_information5 is null OR rei_information5 = 'Y')
238: AND information_type in ('GHR_US_PAR_TERM_RET_GRADE',
239: 'GHR_US_PAR_TERM_RG_PROMO',

Line 244: FROM ghr_pa_request_extra_info

240: 'GHR_US_PAR_TERM_RG_POSN_CHG')
241: )
242: )
243: AND pei.person_extra_info_id NOT IN (SELECT rei_information3
244: FROM ghr_pa_request_extra_info
245: WHERE pa_request_id = p_pa_request_id
246: AND information_type in ( 'GHR_US_PAR_TERM_RET_GRADE',
247: 'GHR_US_PAR_TERM_RG_PROMO',
248: 'GHR_US_PAR_TERM_RG_POSN_CHG')