APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on HR_ORGANIZATION_UNITS

Line 143: /* Bug: 3638081. Following query is modifed and view org_organization_definitions is replaced with view HR_ORGANIZATION_UNITS

139: --- || ' Org Name:' || p_org
140: --- );
141:
142: BEGIN
143: /* Bug: 3638081. Following query is modifed and view org_organization_definitions is replaced with view HR_ORGANIZATION_UNITS
144: SELECT
145: OPEN_FLAG
146: INTO
147: l_open_flag

Line 162: ,HR_ORGANIZATION_UNITS HOU

158: INTO
159: l_open_flag
160: FROM
161: org_acct_periods oop
162: ,HR_ORGANIZATION_UNITS HOU
163: WHERE oop.acct_period_id = p_acct_period_id
164: AND oop.organization_id = HOU.organization_id
165: AND HOU.name = p_org;
166:

Line 818: l_orgid hr_organization_units.organization_id%TYPE;

814: IS
815:
816: l_org_code_list INV_ORGHIERARCHY_PVT.OrgID_tbl_type;
817:
818: l_orgid hr_organization_units.organization_id%TYPE;
819: l_org_name VARCHAR2(240) := NULL;
820:
821:
822: l_index BINARY_INTEGER;

Line 925: HR_organization_units

921: SELECT
922: name
923: , date_from
924: FROM
925: HR_organization_units
926: WHERE ORGANIZATION_ID = c_org_id;
927:
928: -- Select the periods from GL_PERIODS
929: -- that are eligible to be

Line 1229: , hr_organization_units orgu

1225: , l_org_from_date
1226: FROM
1227: gl_sets_of_books glstb
1228: , org_organization_definitions orgdef
1229: , hr_organization_units orgu
1230: WHERE orgdef.organization_id = p_org_hierarchy_origin
1231: AND glstb.set_of_books_id = orgdef.set_of_books_id
1232: AND orgu.organization_id = orgdef.organization_id
1233: AND orgu.business_group_id = orgdef.business_group_id ;

Line 1245: , hr_organization_units HOU

1241: , l_sob_period_type
1242: , l_org_from_date
1243: FROM
1244: MTL_PARAMETERS MP
1245: , hr_organization_units HOU
1246: , HR_ORGANIZATION_INFORMATION HOI
1247: , gl_sets_of_books glstb
1248: WHERE HOU.ORGANIZATION_ID = p_org_hierarchy_origin
1249: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID