APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 80: FROM hr_all_organization_units

76:
77: CURSOR lc_get_bg_name
78: IS
79: SELECT name
80: FROM hr_all_organization_units
81: WHERE business_group_id = p_business_group_id
82: AND organization_id = p_business_group_id;
83: --
84: CURSOR lc_get_org_id

Line 156: l_bg_name hr_all_organization_units.name%type default null;

152: l_effective_start_date date default null;
153: l_effective_end_date date default null;
154: l_hire_date date default null;
155: l_term_date date default null;
156: l_bg_name hr_all_organization_units.name%type default null;
157: l_commit_count number default 0;
158: l_org_id_list varchar2(32000);
159: l_per_type_id_list varchar2(2000);
160: l_asg_status_type_id number;