APPS.PAY_PAYRG_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1319: from hr_all_organization_units hou, /* Assignment Org */

1315: paa.assignment_id,
1316: ppa.effective_date,
1317: paa.tax_unit_id))),
1318: (select hou.name
1319: from hr_all_organization_units hou, /* Assignment Org */
1320: per_assignments_f paf
1321: where paf.assignment_id = paa.assignment_id
1322: and ppa.effective_date between
1323: paf.effective_start_date and paf.effective_end_date

Line 1398: from hr_all_organization_units hou1 /* Tax Unit */

1394: if c_option_name = 'GRE' Then
1395:
1396: select hou1.name
1397: into return_val
1398: from hr_all_organization_units hou1 /* Tax Unit */
1399: where hou1.organization_id = c_tax_unit_id
1400: and rownum = 1;
1401:
1402: else

Line 1409: from hr_all_organization_units hou, /* Assignment Org */

1405: 'Organization',hou.name,
1406: 'Location',loc.location_code,
1407: null)
1408: into return_val
1409: from hr_all_organization_units hou, /* Assignment Org */
1410: hr_locations_all loc,
1411: per_assignments_f paf
1412: where paf.assignment_id = c_assignment_id
1413: and c_effective_date between