APPS.PERFRPHR dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 317: per_assignment_extra_info ext,

313: per_jobs job,
314: hr_locations_all loc,
315: hr_ALL_ORGANIZATION_UNITS OU1,
316: HR_ORGANIZATION_INFORMATION OI1,
317: per_assignment_extra_info ext,
318: per_all_assignments_f ass,
319: per_all_people_f peo
320: WHERE adr.person_id(+) = peo.person_id
321: AND adr.primary_flag(+) = 'Y'

Line 423: per_assignment_extra_info ext,

419: per_jobs job,
420: hr_locations_all loc,
421: hr_ALL_ORGANIZATION_UNITS OU1,
422: HR_ORGANIZATION_INFORMATION OI1,
423: per_assignment_extra_info ext,
424: per_all_assignments_f ass,
425: per_all_people_f peo
426: WHERE adr.person_id(+) = peo.person_id
427: AND adr.primary_flag(+) = 'Y'

Line 1078: l_trace := 'Updating per_assignment_extra_info';

1074: fnd_file.put_line(FND_FILE.OUTPUT,l_text);
1075: --
1076: write_report(r_app,'N');
1077: --
1078: l_trace := 'Updating per_assignment_extra_info';
1079: UPDATE per_assignment_extra_info
1080: SET aei_information11 = 'N',
1081: aei_information12 = fnd_date.date_to_canonical(sysdate)
1082: WHERE rowid = r_app.row_id;

Line 1079: UPDATE per_assignment_extra_info

1075: --
1076: write_report(r_app,'N');
1077: --
1078: l_trace := 'Updating per_assignment_extra_info';
1079: UPDATE per_assignment_extra_info
1080: SET aei_information11 = 'N',
1081: aei_information12 = fnd_date.date_to_canonical(sysdate)
1082: WHERE rowid = r_app.row_id;
1083: --