APPS.PER_MX_DATA_PUMP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 47: FROM hr_all_organization_units hou,

43: ) RETURN NUMBER AS
44:
45: CURSOR csr_tax_unit_id IS
46: SELECT hou.organization_id
47: FROM hr_all_organization_units hou,
48: hr_all_organization_units_tl houtl,
49: hr_organization_information hoi,
50: hr_organization_information hoi1
51: WHERE hou.organization_id = hoi.organization_id(+)

Line 48: hr_all_organization_units_tl houtl,

44:
45: CURSOR csr_tax_unit_id IS
46: SELECT hou.organization_id
47: FROM hr_all_organization_units hou,
48: hr_all_organization_units_tl houtl,
49: hr_organization_information hoi,
50: hr_organization_information hoi1
51: WHERE hou.organization_id = hoi.organization_id(+)
52: AND hou.organization_id = hoi1.organization_id

Line 62: l_org_id hr_all_organization_units.organization_id%type;

58: AND houtl.language = userenv('LANG')
59: AND hou.business_group_id = p_business_group_id
60: AND hou.name = p_tax_unit;
61:
62: l_org_id hr_all_organization_units.organization_id%type;
63: l_proc_name varchar2(100);
64: BEGIN
65:
66: l_proc_name := g_proc_name||'GET_TAX_UNIT_ID';