DBA Data[Home] [Help]

APPS.HR_PERSON_FLEX_LOGIC dependencies on HR_API

Line 844: nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)

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)
845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
846:
847: cursor c_org_name is
848: select name

Line 845: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);

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)
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