eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on PER_ALL_ASSIGNMENTS_F

Line 285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;

281: g_ler_id ben_ler_f.ler_id%TYPE;
282: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
284: --
285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;

Line 286: g_employee_category per_all_assignments_f.employment_category%TYPE;

282: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
284: --
285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;

Line 287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;

283: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
284: --
285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;

Line 288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;

284: --
285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;

Line 289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;

285: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;

Line 290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;

286: g_employee_category per_all_assignments_f.employment_category%TYPE;
287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;

Line 291: g_asg_title per_all_assignments_f.title%TYPE;

287: g_employee_barg_unit per_all_assignments_f.bargaining_unit_code%TYPE;
288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;

Line 292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;

288: g_hourly_salaried_code per_all_assignments_f.hourly_salaried_code%TYPE;
289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;

Line 293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;

289: g_labour_union_member_flag per_all_assignments_f.labour_union_member_flag%TYPE;
290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;

Line 294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;

290: g_manager_flag per_all_assignments_f.manager_flag%TYPE;
291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;

Line 295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;

291: g_asg_title per_all_assignments_f.title%TYPE;
292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;

Line 296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;

292: g_asg_attr_1 per_all_assignments_f.ass_attribute1%TYPE;
293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;

Line 297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;

293: g_asg_attr_2 per_all_assignments_f.ass_attribute2%TYPE;
294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;

Line 298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;

294: g_asg_attr_3 per_all_assignments_f.ass_attribute3%TYPE;
295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;

Line 299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;

295: g_asg_attr_4 per_all_assignments_f.ass_attribute4%TYPE;
296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

Line 300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;

296: g_asg_attr_5 per_all_assignments_f.ass_attribute5%TYPE;
297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;

Line 301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;

297: g_asg_attr_6 per_all_assignments_f.ass_attribute6%TYPE;
298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;

Line 302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;

298: g_asg_attr_7 per_all_assignments_f.ass_attribute7%TYPE;
299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;

Line 303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

299: g_asg_attr_8 per_all_assignments_f.ass_attribute8%TYPE;
300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;

Line 304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;

300: g_asg_attr_9 per_all_assignments_f.ass_attribute9%TYPE;
301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;

Line 305: g_asg_created_by per_all_assignments_f.created_by%TYPE;

301: g_asg_attr_10 per_all_assignments_f.ass_attribute10%TYPE;
302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;

Line 306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;

302: g_asg_last_update_date per_all_assignments_f.last_update_date%TYPE;
303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;

Line 307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;

303: g_asg_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;
311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;

Line 308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;

304: g_asg_last_update_login per_all_assignments_f.last_update_login%TYPE;
305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;
311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;

Line 309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;

305: g_asg_created_by per_all_assignments_f.created_by%TYPE;
306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;
311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;
313: g_base_salary number ;

Line 310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;

306: g_asg_creation_date per_all_assignments_f.creation_date%TYPE;
307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;
311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;
313: g_base_salary number ;
314: --

Line 311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;

307: g_asg_normal_hours per_all_assignments_f.normal_hours%TYPE;
308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;
311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;
313: g_base_salary number ;
314: --
315: g_abs_reason per_absence_attendances.abs_attendance_reason_id%TYPE;

Line 312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;

308: g_asg_frequency per_all_assignments_f.frequency%TYPE ;
309: g_asg_time_normal_start per_all_assignments_f.time_normal_start%TYPE;
310: g_asg_time_normal_finish per_all_assignments_f.time_normal_finish%TYPE;
311: g_asg_supervisor_id per_all_assignments_f.supervisor_id%TYPE;
312: g_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%TYPE;
313: g_base_salary number ;
314: --
315: g_abs_reason per_absence_attendances.abs_attendance_reason_id%TYPE;
316: g_abs_category per_absence_attendance_types.absence_category%TYPE;