APPS.PAY_MX_PAYREG_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1612: FROM hr_all_organization_units hou1

1608: --payroll name(PAY_NAME)
1609: /* IF c_option_name = 'GRE' THEN
1610: SELECT hou1.name
1611: INTO return_val
1612: FROM hr_all_organization_units hou1
1613: WHERE hou1.organization_id = c_tax_unit_id
1614: AND rownum = 1;
1615: ELSE
1616: SELECT DECODE(c_option_name,

Line 1621: FROM hr_all_organization_units hou,

1617: 'Organization',hou.name,
1618: 'Location',loc.location_code,
1619: NULL)
1620: INTO return_val
1621: FROM hr_all_organization_units hou,
1622: hr_locations_all loc,
1623: per_assignments_f paf
1624: WHERE paf.assignment_id = c_assignment_id
1625: AND c_effective_date BETWEEN

Line 1665: FROM hr_all_organization_units hou1

1661: ELSIF c_option_name = 'GRE' Then
1662: hr_utility.set_location ('Entering '||l_proc_name ,25);
1663: SELECT hou1.name
1664: INTO return_val
1665: FROM hr_all_organization_units hou1
1666: WHERE hou1.organization_id = c_tax_unit_id
1667: AND rownum = 1;
1668: END IF;
1669: