APPS.HR_SUPERVISOR_SS dependencies on PER_PEOPLE_F

Line 9: last_name per_people_f.last_name%type DEFAULT NULL,

5: -- declare a table for storing txn steps
6: gtt_transaction_steps hr_transaction_ss.transaction_table ;
7:
8: TYPE lrt_direct_reports is RECORD (
9: last_name per_people_f.last_name%type DEFAULT NULL,
10: first_name per_people_f.first_name%type ,
11: person_id per_people_f.person_id%type ,
12: full_name per_people_f.full_name%type ,
13: assignment_id per_assignments_f.assignment_id%type,

Line 10: first_name per_people_f.first_name%type ,

6: gtt_transaction_steps hr_transaction_ss.transaction_table ;
7:
8: TYPE lrt_direct_reports is RECORD (
9: last_name per_people_f.last_name%type DEFAULT NULL,
10: first_name per_people_f.first_name%type ,
11: person_id per_people_f.person_id%type ,
12: full_name per_people_f.full_name%type ,
13: assignment_id per_assignments_f.assignment_id%type,
14: supervisor_id per_people_f.person_id%type,

Line 11: person_id per_people_f.person_id%type ,

7:
8: TYPE lrt_direct_reports is RECORD (
9: last_name per_people_f.last_name%type DEFAULT NULL,
10: first_name per_people_f.first_name%type ,
11: person_id per_people_f.person_id%type ,
12: full_name per_people_f.full_name%type ,
13: assignment_id per_assignments_f.assignment_id%type,
14: supervisor_id per_people_f.person_id%type,
15: -- Assignment Security

Line 12: full_name per_people_f.full_name%type ,

8: TYPE lrt_direct_reports is RECORD (
9: last_name per_people_f.last_name%type DEFAULT NULL,
10: first_name per_people_f.first_name%type ,
11: person_id per_people_f.person_id%type ,
12: full_name per_people_f.full_name%type ,
13: assignment_id per_assignments_f.assignment_id%type,
14: supervisor_id per_people_f.person_id%type,
15: -- Assignment Security
16: supervisor_assignment_id per_assignments_f.supervisor_assignment_id%type,

Line 14: supervisor_id per_people_f.person_id%type,

10: first_name per_people_f.first_name%type ,
11: person_id per_people_f.person_id%type ,
12: full_name per_people_f.full_name%type ,
13: assignment_id per_assignments_f.assignment_id%type,
14: supervisor_id per_people_f.person_id%type,
15: -- Assignment Security
16: supervisor_assignment_id per_assignments_f.supervisor_assignment_id%type,
17:
18: supervisor_name per_people_f.full_name%type ,

Line 18: supervisor_name per_people_f.full_name%type ,

14: supervisor_id per_people_f.person_id%type,
15: -- Assignment Security
16: supervisor_assignment_id per_assignments_f.supervisor_assignment_id%type,
17:
18: supervisor_name per_people_f.full_name%type ,
19: effective_date VARCHAR2(20) DEFAULT NULL,
20: error_code VARCHAR2(10) );
21:
22: TYPE ltt_direct_reports is table of lrt_direct_reports

Line 116: p_old_sup_name per_people_f.full_name%type default NULL,

112: p_new_sup_id NUMBER default NULL,
113: -- Assignment Security
114: p_new_sup_asg_id NUMBER default NULL,
115:
116: p_old_sup_name per_people_f.full_name%type default NULL,
117: p_new_sup_name per_people_f.full_name%type,
118: p_emp_name per_people_f.full_name%type,
119: p_emp_id per_people_f.person_id%type default NULL,
120: p_effective_date Date ,

Line 117: p_new_sup_name per_people_f.full_name%type,

113: -- Assignment Security
114: p_new_sup_asg_id NUMBER default NULL,
115:
116: p_old_sup_name per_people_f.full_name%type default NULL,
117: p_new_sup_name per_people_f.full_name%type,
118: p_emp_name per_people_f.full_name%type,
119: p_emp_id per_people_f.person_id%type default NULL,
120: p_effective_date Date ,
121: p_assignment_id NUMBER ,

Line 118: p_emp_name per_people_f.full_name%type,

114: p_new_sup_asg_id NUMBER default NULL,
115:
116: p_old_sup_name per_people_f.full_name%type default NULL,
117: p_new_sup_name per_people_f.full_name%type,
118: p_emp_name per_people_f.full_name%type,
119: p_emp_id per_people_f.person_id%type default NULL,
120: p_effective_date Date ,
121: p_assignment_id NUMBER ,
122: p_section_code IN VARCHAR2,

Line 119: p_emp_id per_people_f.person_id%type default NULL,

115:
116: p_old_sup_name per_people_f.full_name%type default NULL,
117: p_new_sup_name per_people_f.full_name%type,
118: p_emp_name per_people_f.full_name%type,
119: p_emp_id per_people_f.person_id%type default NULL,
120: p_effective_date Date ,
121: p_assignment_id NUMBER ,
122: p_section_code IN VARCHAR2,
123: p_row_num NUMBER DEFAULT 0,