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.FII_SETUP_VAL_C dependencies on FND_DATE

Line 108: fnd_date.canonical_to_date(hoi.org_information3) eff_date

104: select org.name organization,
105: com.flex_value company,
106: cc.flex_value cost_center,
107: per.full_name manager,
108: fnd_date.canonical_to_date(hoi.org_information3) eff_date
109: from fii_ccc_mgr_gt gt,
110: hr_all_organization_units org,
111: fnd_flex_values com,
112: fnd_flex_values cc,

Line 195: AND nvl( fnd_date.canonical_to_date( org_information3 ),

191: FROM hr_organization_information ccc_tbl,
192: ( SELECT organization_id, org_information2
193: FROM hr_organization_information b
194: WHERE org_information_context = 'Organization Name Alias'
195: AND nvl( fnd_date.canonical_to_date( org_information3 ),
196: sysdate + 1 ) <= sysdate
197: AND nvl( fnd_date.canonical_to_date( org_information4 ),
198: sysdate + 1 ) >= sysdate
199: ) mgr_tbl,

Line 197: AND nvl( fnd_date.canonical_to_date( org_information4 ),

193: FROM hr_organization_information b
194: WHERE org_information_context = 'Organization Name Alias'
195: AND nvl( fnd_date.canonical_to_date( org_information3 ),
196: sysdate + 1 ) <= sysdate
197: AND nvl( fnd_date.canonical_to_date( org_information4 ),
198: sysdate + 1 ) >= sysdate
199: ) mgr_tbl,
200: hr_organization_information org,
201: fnd_flex_values fv1,

Line 560: and (nvl( fnd_date.canonical_to_date( mgr.org_information3 ),

556: and not exists
557: (select 1
558: from hr_organization_information mgr
559: where mgr.org_information_context = 'Organization Name Alias'
560: and (nvl( fnd_date.canonical_to_date( mgr.org_information3 ),
561: sysdate + 1 ) <= sysdate
562: or nvl( fnd_date.canonical_to_date( mgr.org_information4 ),
563: sysdate + 1 ) >= sysdate)
564: and mgr.org_information2 is not null

Line 562: or nvl( fnd_date.canonical_to_date( mgr.org_information4 ),

558: from hr_organization_information mgr
559: where mgr.org_information_context = 'Organization Name Alias'
560: and (nvl( fnd_date.canonical_to_date( mgr.org_information3 ),
561: sysdate + 1 ) <= sysdate
562: or nvl( fnd_date.canonical_to_date( mgr.org_information4 ),
563: sysdate + 1 ) >= sysdate)
564: and mgr.org_information2 is not null
565: and mgr.organization_id = org.organization_id);
566:

Line 575: and (nvl( fnd_date.canonical_to_date( org_information3 ),

571: from
572: ( select organization_id, org_information2
573: from hr_organization_information b
574: where org_information_context = 'Organization Name Alias'
575: and (nvl( fnd_date.canonical_to_date( org_information3 ),
576: sysdate + 1 ) <= sysdate
577: or nvl( fnd_date.canonical_to_date( org_information4 ),
578: sysdate + 1 ) >= sysdate)
579: and org_information2 is not null

Line 577: or nvl( fnd_date.canonical_to_date( org_information4 ),

573: from hr_organization_information b
574: where org_information_context = 'Organization Name Alias'
575: and (nvl( fnd_date.canonical_to_date( org_information3 ),
576: sysdate + 1 ) <= sysdate
577: or nvl( fnd_date.canonical_to_date( org_information4 ),
578: sysdate + 1 ) >= sysdate)
579: and org_information2 is not null
580: ) mgr_tbl,
581: hr_all_organization_units org,

Line 595: and (nvl( fnd_date.canonical_to_date( org_information3 ),

591: select distinct per.full_name, ast.per_system_status
592: from ( select organization_id, org_information2
593: from hr_organization_information b
594: where org_information_context = 'Organization Name Alias'
595: and (nvl( fnd_date.canonical_to_date( org_information3 ),
596: sysdate + 1 ) <= sysdate
597: or nvl( fnd_date.canonical_to_date( org_information4 ),
598: sysdate + 1 ) >= sysdate)
599: and org_information2 is not null) ct,

Line 597: or nvl( fnd_date.canonical_to_date( org_information4 ),

593: from hr_organization_information b
594: where org_information_context = 'Organization Name Alias'
595: and (nvl( fnd_date.canonical_to_date( org_information3 ),
596: sysdate + 1 ) <= sysdate
597: or nvl( fnd_date.canonical_to_date( org_information4 ),
598: sysdate + 1 ) >= sysdate)
599: and org_information2 is not null) ct,
600: hri_cs_suph suph,
601: per_assignment_status_types ast,

Line 618: and nvl( fnd_date.canonical_to_date( org_information3 ),

614: FROM hr_organization_information ccc_tbl,
615: ( select organization_id, org_information2
616: from hr_organization_information
617: where org_information_context = 'Organization Name Alias'
618: and nvl( fnd_date.canonical_to_date( org_information3 ),
619: sysdate + 1 ) <= sysdate
620: and nvl( fnd_date.canonical_to_date( org_information4 ),
621: sysdate + 1 ) >= sysdate
622: ) mgr_tbl,

Line 620: and nvl( fnd_date.canonical_to_date( org_information4 ),

616: from hr_organization_information
617: where org_information_context = 'Organization Name Alias'
618: and nvl( fnd_date.canonical_to_date( org_information3 ),
619: sysdate + 1 ) <= sysdate
620: and nvl( fnd_date.canonical_to_date( org_information4 ),
621: sysdate + 1 ) >= sysdate
622: ) mgr_tbl,
623: hr_organization_information org,
624: hr_all_organization_units hou,

Line 658: and nvl( fnd_date.canonical_to_date( org_information3 ),

654: from hr_organization_information ccc_tbl,
655: ( select organization_id, org_information2
656: from hr_organization_information
657: where org_information_context = 'Organization Name Alias'
658: and nvl( fnd_date.canonical_to_date( org_information3 ),
659: sysdate + 1 ) <= sysdate
660: and nvl( fnd_date.canonical_to_date( org_information4 ),
661: sysdate + 1 ) >= sysdate
662: ) mgr_tbl,

Line 660: and nvl( fnd_date.canonical_to_date( org_information4 ),

656: from hr_organization_information
657: where org_information_context = 'Organization Name Alias'
658: and nvl( fnd_date.canonical_to_date( org_information3 ),
659: sysdate + 1 ) <= sysdate
660: and nvl( fnd_date.canonical_to_date( org_information4 ),
661: sysdate + 1 ) >= sysdate
662: ) mgr_tbl,
663: hr_organization_information org,
664: fnd_flex_values fv1,

Line 740: and nvl( fnd_date.canonical_to_date( org_information3 ),

736: from hr_organization_information ccc_tbl,
737: ( select organization_id, org_information2
738: from hr_organization_information
739: where org_information_context = 'Organization Name Alias'
740: and nvl( fnd_date.canonical_to_date( org_information3 ),
741: sysdate + 1 ) <= sysdate
742: and nvl( fnd_date.canonical_to_date( org_information4 ),
743: sysdate + 1 ) >= sysdate
744: ) mgr_tbl,

Line 742: and nvl( fnd_date.canonical_to_date( org_information4 ),

738: from hr_organization_information
739: where org_information_context = 'Organization Name Alias'
740: and nvl( fnd_date.canonical_to_date( org_information3 ),
741: sysdate + 1 ) <= sysdate
742: and nvl( fnd_date.canonical_to_date( org_information4 ),
743: sysdate + 1 ) >= sysdate
744: ) mgr_tbl,
745: hr_organization_information org,
746: fnd_flex_values fv1,