APPS.PER_ASG_SHD dependencies on PER_ALL_ASSIGNMENTS_F

Line 10: assignment_id per_all_assignments_f.assignment_id%TYPE,

6: -- ----------------------------------------------------------------------------
7: --
8: Type g_rec_type Is Record
9: (
10: assignment_id per_all_assignments_f.assignment_id%TYPE,
11: effective_start_date date,
12: effective_end_date date,
13: business_group_id number(15),
14: recruiter_id per_all_assignments_f.recruiter_id%TYPE,

Line 14: recruiter_id per_all_assignments_f.recruiter_id%TYPE,

10: assignment_id per_all_assignments_f.assignment_id%TYPE,
11: effective_start_date date,
12: effective_end_date date,
13: business_group_id number(15),
14: recruiter_id per_all_assignments_f.recruiter_id%TYPE,
15: grade_id number(15),
16: position_id number(15),
17: job_id number(15),
18: assignment_status_type_id number(9),

Line 21: person_referred_by_id per_all_assignments_f.person_referred_by_id%TYPE,

17: job_id number(15),
18: assignment_status_type_id number(9),
19: payroll_id number(9),
20: location_id number(15),
21: person_referred_by_id per_all_assignments_f.person_referred_by_id%TYPE,
22: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
23: special_ceiling_step_id number(15),
24: person_id per_all_assignments_f.person_id%TYPE,
25: recruitment_activity_id number(15),

Line 22: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

18: assignment_status_type_id number(9),
19: payroll_id number(9),
20: location_id number(15),
21: person_referred_by_id per_all_assignments_f.person_referred_by_id%TYPE,
22: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
23: special_ceiling_step_id number(15),
24: person_id per_all_assignments_f.person_id%TYPE,
25: recruitment_activity_id number(15),
26: source_organization_id number(15),

Line 24: person_id per_all_assignments_f.person_id%TYPE,

20: location_id number(15),
21: person_referred_by_id per_all_assignments_f.person_referred_by_id%TYPE,
22: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
23: special_ceiling_step_id number(15),
24: person_id per_all_assignments_f.person_id%TYPE,
25: recruitment_activity_id number(15),
26: source_organization_id number(15),
27: organization_id number(15),
28: people_group_id number(15),

Line 129: g_tab_nam constant varchar2(30) := 'PER_ALL_ASSIGNMENTS_F';

125: -- | Global Definitions - Internal Development Use Only |
126: -- ----------------------------------------------------------------------------
127: --
128: g_old_rec g_rec_type; -- Global record definition
129: g_tab_nam constant varchar2(30) := 'PER_ALL_ASSIGNMENTS_F';
130: g_api_dml boolean; -- Global api dml status
131: --
132: -- ----------------------------------------------------------------------------
133: -- |------------------------< return_api_dml_status >-------------------------|