DBA Data[Home] [Help]

APPS.OTA_TFH_API_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 451: hr_all_organization_units org

447: select pbg.security_group_id,
448: pbg.legislation_code
449: from per_business_groups_perf pbg,
450: ota_finance_headers tfh,
451: hr_all_organization_units org
452: where pbg.business_group_id = org.business_group_id
453: and org.organization_id = tfh.organization_id
454: and tfh.finance_header_id = p_finance_header_id;
455:

Line 550: hr_all_organization_units org

546: cursor csr_leg_code is
547: select legislation_code
548: from per_business_groups_perf pbg,
549: ota_finance_headers tfh,
550: hr_all_organization_units org
551: where pbg.business_group_id = org.business_group_id
552: and org.organization_id = tfh.organization_id
553: and tfh.finance_header_id = p_finance_header_id;
554: