DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_PERIODS_OF_SERVICE

Line 204: g_last_hire_date per_periods_of_service.date_start%TYPE;

200: g_phone_fax per_phones.phone_number%TYPE;
201: g_phone_mobile per_phones.phone_number%TYPE;
202: g_phone_pager per_phones.phone_number%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;

Line 205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;

201: g_phone_mobile per_phones.phone_number%TYPE;
202: g_phone_pager per_phones.phone_number%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;

Line 206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;

202: g_phone_pager per_phones.phone_number%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;

Line 207: g_term_reason per_periods_of_service.leaving_reason%TYPE;

203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;

Line 208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;

204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;

Line 209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;

205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;

Line 210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;

206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;

Line 211: g_pos_created_by per_periods_of_service.created_by%TYPE;

207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;

Line 212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;

208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;

Line 213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;

209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;

Line 214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;

210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;

Line 215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;

211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;

Line 216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;

212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;

Line 217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;

213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;

Line 218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;

214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;

Line 219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;

215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --

Line 220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;

216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
224: g_person_types per_person_types.user_person_type%type ;

Line 221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;

217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
224: g_person_types per_person_types.user_person_type%type ;
225: g_person_type_id per_person_types.person_type_id%type ;

Line 222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;

218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
224: g_person_types per_person_types.user_person_type%type ;
225: g_person_type_id per_person_types.person_type_id%type ;
226: --