DBA Data[Home] [Help]

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1258: hr_organization_units hou_org,

1254: ,lv_assignment_status
1255: from per_person_types ppt,
1256: per_people_f ppf,
1257: hr_locations_all hl,
1258: hr_organization_units hou_org,
1259: per_assignment_status_types past,
1260: per_assignments_f paf
1261: where paf.assignment_id = ln_assignment_id
1262: and ld_effective_date between paf.effective_start_date

Line 1285: from hr_organization_units hou_gre

1281: BEGIN
1282:
1283: select hou_gre.name
1284: into lv_gre_name
1285: from hr_organization_units hou_gre
1286: where hou_gre.organization_id = lv_tax_unit_id;
1287:
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN