APPS.PAY_US_PSD_UPGRADE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1848: hr_organization_units hou,

1844: ,l_date
1845: ,l_mode
1846: ,substr(pumg.city_name,8,6)
1847: FROM hr_organization_information hoi,
1848: hr_organization_units hou,
1849: pay_us_modified_geocodes pumg
1850: WHERE hoi.org_information_context='PSD Reporting Rules'
1851: AND substr(hoi.org_information10,1,6) = substr(pumg.city_name,1,6)
1852: AND pumg.process_type = 'PA'

Line 2084: hr_organization_units hou

2080: substr(pugu.new_juri_code,1,6),
2081: pugu.table_name
2082: FROM pay_us_geo_update pugu,
2083: hr_organization_information hoi,
2084: hr_organization_units hou
2085: WHERE pugu.id = p_id
2086: AND pugu.process_type = 'PA'
2087: AND pugu.process_mode = p_mode
2088: AND pugu.process_date = p_date

Line 2124: hr_organization_units hou

2120: substr(hou.name,1,100),
2121: hou.organization_id
2122: FROM pay_us_geo_update pugu,
2123: hr_organization_information hoi,
2124: hr_organization_units hou
2125: WHERE pugu.id = p_id
2126: AND pugu.process_type = 'PA'
2127: AND pugu.process_mode = p_mode
2128: AND pugu.process_date = p_date

Line 2200: l_gre_name hr_organization_units.name%TYPE;

2196: l_error_assignments NUMBER;
2197: l_not_process_assignments NUMBER;
2198:
2199: -- Added for bug 14213838.
2200: l_gre_name hr_organization_units.name%TYPE;
2201: l_gre_id NUMBER;
2202: l_print_gre_name hr_organization_units.name%TYPE;
2203: l_print_gre_id NUMBER;
2204: l_ff_archive_item_contexts VARCHAR2(10);

Line 2202: l_print_gre_name hr_organization_units.name%TYPE;

2198:
2199: -- Added for bug 14213838.
2200: l_gre_name hr_organization_units.name%TYPE;
2201: l_gre_id NUMBER;
2202: l_print_gre_name hr_organization_units.name%TYPE;
2203: l_print_gre_id NUMBER;
2204: l_ff_archive_item_contexts VARCHAR2(10);
2205: l_hr_organization_information VARCHAR2(10);
2206: l_total_gre_changes NUMBER;