80: --
81: BEGIN
82: --
83: g_refresh_start_date := bis_common_parameters.get_global_start_date;
84: g_refresh_end_date := hr_general.end_of_time;
85: g_full_refresh := 'Y';
86: g_concurrent_flag := 'Y';
87: g_debug_flag := 'Y';
88: --
151: ,SYSDATE
152: FROM hri_cs_suph ,
153: (SELECT hoi.organization_id organization_id,
154: NVL(to_number(hoi.org_information2), -1) manager_person_id ,
155: NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,
156: NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time) end_date
157: FROM hr_organization_information hoi
158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL
152: FROM hri_cs_suph ,
153: (SELECT hoi.organization_id organization_id,
154: NVL(to_number(hoi.org_information2), -1) manager_person_id ,
155: NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,
156: NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time) end_date
157: FROM hr_organization_information hoi
158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL
160: AND EXISTS ( SELECT NULL