DBA Data[Home] [Help]

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1267: hr_organization_units hou_org,

1263: ,lv_assignment_status
1264: from per_person_types ppt,
1265: per_people_f ppf,
1266: hr_locations_all hl,
1267: hr_organization_units hou_org,
1268: per_assignment_status_types past,
1269: per_assignments_f paf
1270: where paf.assignment_id = ln_assignment_id
1271: and ld_effective_date between paf.effective_start_date

Line 1294: from hr_organization_units hou_gre

1290: BEGIN
1291:
1292: select hou_gre.name
1293: into lv_gre_name
1294: from hr_organization_units hou_gre
1295: where hou_gre.organization_id = lv_tax_unit_id;
1296:
1297: EXCEPTION
1298: WHEN NO_DATA_FOUND THEN