APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO

Line 29: l_pei_id per_people_extra_info.person_extra_info_id%type;

25: l_session ghr_history_api.g_session_var_type;
26: l_session1 ghr_history_api.g_session_var_type;
27: --End Bug 5923620
28:
29: l_pei_id per_people_extra_info.person_extra_info_id%type;
30: l_rei_rec ghr_pa_request_extra_info%rowtype ;
31: l_org_rec ghr_pa_request_ei_shadow%rowtype;
32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
33: l_noa_code ghr_nature_of_actions.code%type;

Line 55: FROM per_people_extra_info pei,

51: pei_information7,
52: pei_information8,
53: pei_information9,
54: person_extra_info_id
55: FROM per_people_extra_info pei,
56: pay_user_tables put
57: WHERE pei.person_id = p_person_id
58: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
59: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)

Line 75: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

71: pei_information7,
72: pei_information8,
73: pei_information9,
74: person_extra_info_id
75: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
76: pay_user_tables put
77: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
78: AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
79: AND pei2.person_extra_info_id

Line 88: per_people_extra_info.person_extra_info_id%type) is

84: AND rei.pa_request_id = l_altered_pa_request_id
85: order by 1;
86:
87: Cursor c_866(p_person_extra_info_id in
88: per_people_extra_info.person_extra_info_id%type) is
89: SELECT pei_information1,
90: pei_information2,
91: pei_information3,
92: pei_information4,

Line 99: FROM per_people_extra_info pei

95: pei_information7,
96: pei_information8,
97: pei_information9,
98: person_extra_info_id
99: FROM per_people_extra_info pei
100: WHERE pei.person_extra_info_id = p_person_extra_info_id;
101:
102: cursor c_866_rei_correct is
103: SELECT pei_information1,

Line 113: FROM per_people_extra_info pei

109: pei_information7,
110: pei_information8,
111: pei_information9,
112: person_extra_info_id
113: FROM per_people_extra_info pei
114: WHERE pei.person_extra_info_id in (
115: SELECT rei_information3
116: FROM ghr_pa_request_extra_info
117: WHERE pa_request_id = l_altered_pa_request_id

Line 134: FROM per_people_extra_info pei,pay_user_tables put

130: pei_information9,
131: person_extra_info_id,
132: null terminate_flag,
133: null original_rpa
134: FROM per_people_extra_info pei,pay_user_tables put
135: WHERE pei.person_id = p_person_id
136: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
137: AND put.user_table_id = pei.pei_information6
138: AND p_effective_date

Line 154: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

150: pei_information9,
151: person_extra_info_id,
152: rei_information5 terminate_flag,
153: 'Original RPA' origianl_rpa
154: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
155: pay_user_tables put
156: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
157: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
158: AND pei2.person_extra_info_id

Line 639: l_per_ei_data per_people_extra_info%rowtype;

635: p_refresh_flag in varchar2 default 'Y'
636: )
637: is
638:
639: l_per_ei_data per_people_extra_info%rowtype;
640: l_asg_ei_data per_assignment_extra_info%rowtype;
641: l_pos_ei_data per_position_extra_info%rowtype;
642: l_multiple_error_flag boolean;
643: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;