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 HR_ORGANIZATION_INFORMATION

Line 114: hr_organization_information hoi

110: hr_all_organization_units org,
111: fnd_flex_values com,
112: fnd_flex_values cc,
113: per_all_people_f per,
114: hr_organization_information hoi
115: where gt.company_id = p_com_id
116: and gt.cost_center_id = p_cc_id
117: and gt.ccc_org_id = org.organization_id
118: and gt.company_id = com.flex_value_id

Line 191: FROM hr_organization_information ccc_tbl,

187: WHERE NOT EXISTS (
188: SELECT DISTINCT suph.sup_person_id
189: FROM (SELECT to_number (mgr_tbl.org_information2) manager,
190: ccc_tbl.organization_id ccc_org_id
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 ),

Line 193: FROM hr_organization_information b

189: FROM (SELECT to_number (mgr_tbl.org_information2) manager,
190: ccc_tbl.organization_id ccc_org_id
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 ),

Line 200: hr_organization_information org,

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,
202: fnd_flex_values fv2
203: WHERE ccc_tbl.org_information_context = 'CLASS'
204: AND ccc_tbl.org_information1 = 'CC'

Line 512: and not exists (select 1 from hr_organization_information

508: fnd_flex_values fv_co,
509: fnd_flex_values fv_cc
510: where fv_co.flex_value_id = b.company_id
511: and fv_cc.flex_value_id = b.cost_center_id
512: and not exists (select 1 from hr_organization_information
513: where org_information_context = 'Company Cost Center'
514: and org_information2 = fv_co.flex_value_set_id
515: and org_information3 = fv_co.flex_value
516: and org_information4 = fv_cc.flex_value_set_id

Line 527: hr_organization_information org,

523: org2.name
524: from (select distinct company_id
525: from fii_gl_je_summary_b) b,
526: fnd_flex_values fv_co,
527: hr_organization_information org,
528: hr_all_organization_units org2
529: where fv_co.flex_value_id = b.company_id
530: and org_information_context = 'Company Cost Center'
531: and org_information2 = fv_co.flex_value_set_id

Line 546: hr_organization_information org,

542: from (select distinct company_id, cost_center_id
543: from fii_gl_je_summary_b) b,
544: fnd_flex_values fv_co,
545: fnd_flex_values fv_cc,
546: hr_organization_information org,
547: hr_all_organization_units org2
548: where fv_co.flex_value_id = b.company_id
549: and fv_cc.flex_value_id = b.cost_center_id
550: and org_information_context = 'Company Cost Center'

Line 558: from hr_organization_information mgr

554: and org_information5 = fv_cc.flex_value
555: and org2.organization_id = org.organization_id
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 ),

Line 573: from hr_organization_information b

569: org.name organization,
570: per2.effective_end_date
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 ),

Line 593: from hr_organization_information b

589:
590: CURSOR mgr_status_cur IS
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 ),

Line 614: FROM hr_organization_information ccc_tbl,

610: CURSOR trans_ccc_no_mgr_cur IS
611: SELECT ccc_tbl.organization_id ccc_org_id,
612: rpad(hou.name, 40, ' '), fgj.company_id, fv1.flex_value co,
613: fgj.cost_center_id, fv2.flex_value cc
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 ),

Line 616: from hr_organization_information

612: rpad(hou.name, 40, ' '), fgj.company_id, fv1.flex_value co,
613: fgj.cost_center_id, fv2.flex_value cc
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 ),

Line 623: hr_organization_information org,

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,
625: fnd_flex_values fv1,
626: fnd_flex_values fv2,
627: (select distinct company_id, cost_center_id

Line 654: from hr_organization_information ccc_tbl,

650: fnd_id_flex_segments b,
651: (select distinct v.fin_category_id, v.chart_of_accounts_id
652: from
653: ( select distinct fgj.fin_category_id, fgj.chart_of_accounts_id
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 ),

Line 656: from hr_organization_information

652: from
653: ( select distinct fgj.fin_category_id, fgj.chart_of_accounts_id
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 ),

Line 663: hr_organization_information org,

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,
665: fnd_flex_values fv2,
666: (select distinct company_id, cost_center_id, fin_category_id,
667: chart_of_accounts_id

Line 736: from hr_organization_information ccc_tbl,

732: (select v.fin_category_id, v.chart_of_accounts_id
733: from
734: (select distinct fgj.fin_category_id,
735: fgj.chart_of_accounts_id
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 ),

Line 738: from hr_organization_information

734: (select distinct fgj.fin_category_id,
735: fgj.chart_of_accounts_id
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 ),

Line 745: hr_organization_information org,

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,
747: fnd_flex_values fv2,
748: (select distinct company_id, cost_center_id, fin_category_id,
749: chart_of_accounts_id