APPS.FII_SETUP_VAL_C dependencies on HR_ALL_ORGANIZATION_UNITS

Line 110: hr_all_organization_units org,

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,
113: per_all_people_f per,
114: hr_organization_information hoi

Line 528: hr_all_organization_units org2

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
532: and org_information3 = fv_co.flex_value

Line 547: hr_all_organization_units org2

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'
551: and org_information2 = fv_co.flex_value_set_id

Line 581: hr_all_organization_units org,

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,
582: per_all_people_f per2
583: where org.organization_id = mgr_tbl.organization_id
584: and per2.person_id = mgr_tbl.org_information2
585: and not exists (select 1

Line 624: hr_all_organization_units hou,

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
628: from fii_gl_je_summary_b) fgj