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 87: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date

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

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

84:
85: CURSOR csr_update_access_check IS
86: SELECT hao.organization_id
87: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3) start_date
88: ,fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) end_date
89: ,decode(
90: (decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
91: ,HR_SECURITY.SHOW_RECORD
92: ('HR_ALL_ORGANIZATION_UNITS'

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

148: and ctype.org_classification = class.org_information1
149: and class.org_information_context = 'CLASS'
150: and class.org_information2 = 'Y'
151: and class.organization_id = cost_center.organization_id)
152: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
153: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
154: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
155: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
156: from hr_organization_information oi

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

149: and class.org_information_context = 'CLASS'
150: and class.org_information2 = 'Y'
151: and class.organization_id = cost_center.organization_id)
152: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
153: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
154: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
155: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
156: from hr_organization_information oi
157: where oi.org_information_context = 'Organization Name Alias'

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

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

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

151: and class.organization_id = cost_center.organization_id)
152: AND (nvl(fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4),ld_effective_date) >= ld_effective_date
153: Or (fnd_date.canonical_to_date(cost_center.ORG_INFORMATION4) <= ld_effective_date
154: and fnd_date.canonical_to_date(cost_center.ORG_INFORMATION3)
155: = (select max(fnd_date.canonical_to_date(oi.ORG_INFORMATION3))
156: from hr_organization_information oi
157: where oi.org_information_context = 'Organization Name Alias'
158: and oi.organization_id = cost_center.organization_id))); -- 2476134
159: