DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1435: hr_all_organization_units_tl orgs

1431: FROM
1432: (SELECT users.user_id
1433: FROM pon_employees_current_v emp,
1434: fnd_user users ,
1435: hr_all_organization_units_tl orgs
1436: WHERE emp.person_id = users.employee_id
1437: AND users.start_date <= SYSDATE
1438: AND NVL(users.end_date, SYSDATE) >= SYSDATE
1439: AND emp.organization_id = orgs.organization_id

Line 6737: , hr_all_organization_units_tl haou

6733: INTO
6734: l_org_default_data
6735: from
6736: po_system_parameters_all psp
6737: , hr_all_organization_units_tl haou
6738: , financials_system_params_all fsp
6739: , gl_sets_of_books sob
6740: , hr_locations_all_tl bill_to
6741: , hr_locations_all_tl ship_to