DBA Data[Home] [Help]

APPS.HR_PERSON_FLEX_LOGIC dependencies on HR_ORGANIZATION_INFORMATION

Line 825: hr_organization_information

821: /*****************************************************
822: Function : GetOrgAliasName
823: Description : This function returns alias name for
824: for Organization in
825: hr_organization_information
826: else returns name from
827: hr_organization_units
828: Inputs : Organization_id
829: Report Date

Line 840: from hr_organization_information

836: RETURN VARCHAR2 IS
837:
838: cursor c_org_alias_name is
839: select substr(org_information1,1,60)
840: from hr_organization_information
841: where organization_id = P_ORGANIZATION_ID
842: and org_information_context = 'Organization Name Alias'
843: and P_REPORT_DATE between
844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)