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_SUPERVISOR_SS dependencies on FND_DATE

Line 82: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date

78: -- that the person has access to either Organization Or Manager.
79:
80: CURSOR csr_update_access_check IS
81: SELECT hao.organization_id
82: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
83: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
84: ,decode(
85: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
86: ,HR_SECURITY.SHOW_RECORD

Line 83: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date

79:
80: CURSOR csr_update_access_check IS
81: SELECT hao.organization_id
82: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
83: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
84: ,decode(
85: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
86: ,HR_SECURITY.SHOW_RECORD
87: ('HR_ALL_ORGANIZATION_UNITS'

Line 147: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date

143: and ctype.org_classification = class.org_information1
144: and class.org_information_context = 'CLASS'
145: and class.org_information2 = 'Y'
146: and class.organization_id = cost_center.organization_id)
147: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
148: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
149: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
150: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
151: from hr_organization_information oi

Line 148: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date

144: and class.org_information_context = 'CLASS'
145: and class.org_information2 = 'Y'
146: and class.organization_id = cost_center.organization_id)
147: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
148: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
149: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
150: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
151: from hr_organization_information oi
152: where oi.org_information_context = 'Organization Name Alias'

Line 149: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)

145: and class.org_information2 = 'Y'
146: and class.organization_id = cost_center.organization_id)
147: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
148: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
149: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
150: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
151: from hr_organization_information oi
152: where oi.org_information_context = 'Organization Name Alias'
153: and oi.organization_id = cost_center.organization_id))); -- 2476134

Line 150: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))

146: and class.organization_id = cost_center.organization_id)
147: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
148: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
149: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
150: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
151: from hr_organization_information oi
152: where oi.org_information_context = 'Organization Name Alias'
153: and oi.organization_id = cost_center.organization_id))); -- 2476134
154: