APPS.PAY_AU_DLEC dependencies on HR_ORGANIZATION_UNITS

Line 71: seg1_name hr_organization_units.name%type,

67: effective_start_date per_all_assignments_f.effective_start_date%type,
68: effective_end_date per_all_assignments_f.effective_end_date%type,
69: segment1 hr_soft_coding_keyflex.segment1%type,
70: prev_segment1 hr_soft_coding_keyflex.segment1%type,
71: seg1_name hr_organization_units.name%type,
72: seg1_prev_name hr_organization_units.name%type,
73: person_id per_all_assignments_f.person_id%type,
74: full_name per_all_people_f.full_name%type
75: );

Line 72: seg1_prev_name hr_organization_units.name%type,

68: effective_end_date per_all_assignments_f.effective_end_date%type,
69: segment1 hr_soft_coding_keyflex.segment1%type,
70: prev_segment1 hr_soft_coding_keyflex.segment1%type,
71: seg1_name hr_organization_units.name%type,
72: seg1_prev_name hr_organization_units.name%type,
73: person_id per_all_assignments_f.person_id%type,
74: full_name per_all_people_f.full_name%type
75: );
76:

Line 178: from hr_organization_units hou

174: -- Get the legal employer name
175:
176: select hou.name
177: into l_asg_tab(i).seg1_name
178: from hr_organization_units hou
179: where l_asg_tab(i).segment1 = hou.organization_id;
180:
181: -- Get the previous legal employer name
182:

Line 185: from hr_organization_units hou

181: -- Get the previous legal employer name
182:
183: select hou.name
184: into l_asg_tab(i).seg1_prev_name
185: from hr_organization_units hou
186: where l_asg_tab(i).prev_segment1 = hou.organization_id;
187:
188: -- Get the persons full name.
189: