APPS.HR_PERSON_FLEX_LOGIC dependencies on HR_ORGANIZATION_UNITS

Line 827: hr_organization_units

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
830: Output : Organization Name
831:

Line 849: from hr_organization_units

845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
846:
847: cursor c_org_name is
848: select name
849: from hr_organization_units
850: where organization_id = P_ORGANIZATION_ID
851: and P_REPORT_DATE between date_from and
852: nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
853: