DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_PERIODS_OF_SERVICE

Line 201: g_last_hire_date per_periods_of_service.date_start%TYPE;

197: g_phone_work per_phones.phone_number%TYPE;
198: g_phone_fax per_phones.phone_number%TYPE;
199: g_phone_mobile per_phones.phone_number%TYPE;
200: --
201: g_last_hire_date per_periods_of_service.date_start%TYPE;
202: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
203: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
204: g_term_reason per_periods_of_service.leaving_reason%TYPE;
205: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;

Line 202: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;

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

Line 203: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;

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

Line 204: g_term_reason per_periods_of_service.leaving_reason%TYPE;

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

Line 205: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;

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

Line 206: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;

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

Line 207: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;

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

Line 208: g_pos_created_by per_periods_of_service.created_by%TYPE;

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

Line 209: g_pos_creation_date per_periods_of_service.creation_date%TYPE;

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

Line 210: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;

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

Line 211: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;

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

Line 212: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;

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

Line 213: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;

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

Line 214: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;

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

Line 215: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;

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

Line 216: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;

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

Line 217: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;

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

Line 218: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;

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

Line 219: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;

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