APPS.GHR_PD_COVERSHEET_DATA dependencies on PER_POSITION_EXTRA_INFO

Line 18: FROM per_position_extra_info

14: SELECT DECODE(p_info_number,
15: 3,poei_information3,
16: 5,poei_information5,
17: 12,poei_information12)
18: FROM per_position_extra_info
19: WHERE information_type = p_info_type
20: AND position_id = p_position_id;
21:
22: l_position_group per_position_extra_info.poei_information1%TYPE;

Line 22: l_position_group per_position_extra_info.poei_information1%TYPE;

18: FROM per_position_extra_info
19: WHERE information_type = p_info_type
20: AND position_id = p_position_id;
21:
22: l_position_group per_position_extra_info.poei_information1%TYPE;
23:
24: BEGIN
25:
26: OPEN c_get_position_group;

Line 55: l_gen_emp_return per_position_extra_info.poei_information1%TYPE;

51: FROM ghr_pa_request_extra_info
52: WHERE information_type = 'GHR_US_PD_GEN_EMP'
53: AND pa_request_id = p_pa_req_id;
54:
55: l_gen_emp_return per_position_extra_info.poei_information1%TYPE;
56: BEGIN
57:
58: OPEN c_pdi_gen_emp;
59: FETCH c_pdi_gen_emp INTO l_gen_emp_return;