eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_HRHD_INITIAL_LOAD dependencies on FND_DATE

Line 303: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)

299: where ppf.person_id = hrorg1.ORG_INFORMATION2
300: and ppf.business_group_id = org.business_group_id
301: and hrorg1.org_information_context = 'Organization Name Alias'
302: and hrorg1.organization_id = org.organization_id
303: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
304: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
305: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
306:
307: from hr_all_organization_units org,hr_all_organization_units_tl TL

Line 304: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))

300: and ppf.business_group_id = org.business_group_id
301: and hrorg1.org_information_context = 'Organization Name Alias'
302: and hrorg1.organization_id = org.organization_id
303: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
304: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
305: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
306:
307: from hr_all_organization_units org,hr_all_organization_units_tl TL
308: ,hr_organization_information hrorg

Line 305: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID

301: and hrorg1.org_information_context = 'Organization Name Alias'
302: and hrorg1.organization_id = org.organization_id
303: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
304: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
305: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
306:
307: from hr_all_organization_units org,hr_all_organization_units_tl TL
308: ,hr_organization_information hrorg
309: where tl.organization_id = org.organization_id

Line 327: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)

323: where ppf.person_id = hrorg1.ORG_INFORMATION2
324: and ppf.business_group_id = org.business_group_id
325: and hrorg1.org_information_context = 'Organization Name Alias'
326: and hrorg1.organization_id = org.organization_id
327: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
328: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
329: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
330:
331: from hr_all_organization_units org,hr_all_organization_units_tl TL

Line 328: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))

324: and ppf.business_group_id = org.business_group_id
325: and hrorg1.org_information_context = 'Organization Name Alias'
326: and hrorg1.organization_id = org.organization_id
327: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
328: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
329: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
330:
331: from hr_all_organization_units org,hr_all_organization_units_tl TL
332: ,hr_organization_information hrorg

Line 329: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID

325: and hrorg1.org_information_context = 'Organization Name Alias'
326: and hrorg1.organization_id = org.organization_id
327: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
328: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
329: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
330:
331: from hr_all_organization_units org,hr_all_organization_units_tl TL
332: ,hr_organization_information hrorg
333: where tl.organization_id = org.organization_id