APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO

Line 37: l_pei_id per_people_extra_info.person_extra_info_id%type;

33: l_session ghr_history_api.g_session_var_type;
34: l_session1 ghr_history_api.g_session_var_type;
35: --End Bug 5923620
36:
37: l_pei_id per_people_extra_info.person_extra_info_id%type;
38: l_rei_rec ghr_pa_request_extra_info%rowtype ;
39: l_org_rec ghr_pa_request_ei_shadow%rowtype;
40: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
41: l_noa_code ghr_nature_of_actions.code%type;

Line 63: FROM per_people_extra_info pei,

59: pei_information7,
60: pei_information8,
61: pei_information9,
62: person_extra_info_id
63: FROM per_people_extra_info pei,
64: pay_user_tables put
65: WHERE pei.person_id = p_person_id
66: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
67: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)

Line 83: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

79: pei_information7,
80: pei_information8,
81: pei_information9,
82: person_extra_info_id
83: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
84: pay_user_tables put
85: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
86: AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
87: AND pei2.person_extra_info_id

Line 97: per_people_extra_info.person_extra_info_id%type) is

93: order by 1;
94:
95: --Bug # 5584845
96: /* Cursor c_866(p_person_extra_info_id in
97: per_people_extra_info.person_extra_info_id%type) is
98: SELECT pei_information1,
99: pei_information2,
100: pei_information3,
101: pei_information4,

Line 108: FROM per_people_extra_info pei

104: pei_information7,
105: pei_information8,
106: pei_information9,
107: person_extra_info_id
108: FROM per_people_extra_info pei
109: WHERE pei.person_extra_info_id = p_person_extra_info_id;*/
110:
111: Cursor c_866
112: is

Line 123: FROM per_people_extra_info pei,pay_user_tables put

119: pei_information7,
120: pei_information8,
121: pei_information9,
122: person_extra_info_id
123: FROM per_people_extra_info pei,pay_user_tables put
124: WHERE pei.person_id = p_person_id
125: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
126: AND put.user_table_id = pei.pei_information6
127: AND p_effective_date

Line 146: FROM per_people_extra_info pei

142: pei_information7,
143: pei_information8,
144: pei_information9,
145: person_extra_info_id
146: FROM per_people_extra_info pei
147: WHERE pei.person_extra_info_id in (
148: SELECT rei_information3
149: FROM ghr_pa_request_extra_info
150: WHERE pa_request_id = l_altered_pa_request_id

Line 167: FROM per_people_extra_info pei,pay_user_tables put

163: pei_information9,
164: person_extra_info_id,
165: null terminate_flag,
166: null original_rpa
167: FROM per_people_extra_info pei,pay_user_tables put
168: WHERE pei.person_id = p_person_id
169: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
170: AND put.user_table_id = pei.pei_information6
171: AND p_effective_date

Line 187: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

183: pei_information9,
184: person_extra_info_id,
185: rei_information5 terminate_flag,
186: 'Original RPA' origianl_rpa
187: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
188: pay_user_tables put
189: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
190: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
191: AND pei2.person_extra_info_id

Line 698: l_per_ei_data per_people_extra_info%rowtype;

694: p_refresh_flag in varchar2 default 'Y'
695: )
696: is
697:
698: l_per_ei_data per_people_extra_info%rowtype;
699: l_asg_ei_data per_assignment_extra_info%rowtype;
700: l_pos_ei_data per_position_extra_info%rowtype;
701: l_multiple_error_flag boolean;
702: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;