APPS.GHR_US_NFC_EXTRACTS dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 217: RETURN ghr_pa_request_extra_info%ROWTYPE IS

213: --===========================================================================
214: FUNCTION get_rpa_extra_info_val (p_rpa_req_id IN NUMBER
215: ,p_info_type IN VARCHAR2
216: )
217: RETURN ghr_pa_request_extra_info%ROWTYPE IS
218:
219: CURSOR c_get_val (cp_rpa_req_id NUMBER
220: ,cp_info_type ghr_pa_request_extra_info.information_type%TYPE
221: )

Line 220: ,cp_info_type ghr_pa_request_extra_info.information_type%TYPE

216: )
217: RETURN ghr_pa_request_extra_info%ROWTYPE IS
218:
219: CURSOR c_get_val (cp_rpa_req_id NUMBER
220: ,cp_info_type ghr_pa_request_extra_info.information_type%TYPE
221: )
222: IS
223: SELECT *
224: FROM ghr_pa_request_extra_info gpre

Line 224: FROM ghr_pa_request_extra_info gpre

220: ,cp_info_type ghr_pa_request_extra_info.information_type%TYPE
221: )
222: IS
223: SELECT *
224: FROM ghr_pa_request_extra_info gpre
225: WHERE gpre.pa_request_id=cp_rpa_req_id
226: AND information_type=cp_info_type;
227:
228: l_get_val ghr_pa_request_extra_info%ROWTYPE;

Line 228: l_get_val ghr_pa_request_extra_info%ROWTYPE;

224: FROM ghr_pa_request_extra_info gpre
225: WHERE gpre.pa_request_id=cp_rpa_req_id
226: AND information_type=cp_info_type;
227:
228: l_get_val ghr_pa_request_extra_info%ROWTYPE;
229:
230: BEGIN
231:
232: OPEN c_get_val (p_rpa_req_id

Line 1120: FROM ghr_pa_request_extra_info gpre

1116: ,cp_information_type VARCHAR2
1117: )
1118: IS
1119: SELECT *
1120: FROM ghr_pa_request_extra_info gpre
1121: --WHERE gpre.request_id = cp_request_id Bug 4641232 Sundar
1122: WHERE gpre.pa_request_id = cp_request_id
1123: AND gpre.information_type = cp_information_type;
1124:

Line 1208: l_get_ei_val ghr_pa_request_extra_info%ROWTYPE;

1204: l_get_extra_info c_get_extra_info%ROWTYPE;
1205: l_temp1 varchar2(80);
1206: l_get_state c_get_state%ROWTYPE;
1207: l_get_city c_get_city%ROWTYPE;
1208: l_get_ei_val ghr_pa_request_extra_info%ROWTYPE;
1209: BEGIN
1210:
1211: l_no_rpa_count := FALSE;
1212: g_rpa_awd_attr(p_request_id).assignment_id := p_assignment_id;

Line 1509: l_get_ei_val ghr_pa_request_extra_info%ROWTYPE;

1505: l_mast_pos c_mast_pos%ROWTYPE;
1506: l_position_id hr_all_positions_f.position_id%TYPE;
1507: l_out_val pay_element_entry_values_f.screen_entry_value%type;
1508: l_pos_num VARCHAR2(20);
1509: l_get_ei_val ghr_pa_request_extra_info%ROWTYPE;
1510: l_temp_var NUMBER;
1511: BEGIN
1512:
1513: build_rules;