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 828: l_orgid hr_organization_units.organization_id%TYPE;

824: IS
825:
826: l_org_code_list INV_ORGHIERARCHY_PVT.OrgID_tbl_type;
827:
828: l_orgid hr_organization_units.organization_id%TYPE;
829: l_org_name VARCHAR2(240) := NULL;
830:
831:
832: l_index BINARY_INTEGER;

Line 935: HR_organization_units

931: SELECT
932: name
933: , date_from
934: FROM
935: HR_organization_units
936: WHERE ORGANIZATION_ID = c_org_id;
937:
938: -- Select the periods from GL_PERIODS
939: -- that are eligible to be

Line 1243: , hr_organization_units orgu

1239: , l_org_from_date
1240: FROM
1241: gl_sets_of_books glstb
1242: , org_organization_definitions orgdef
1243: , hr_organization_units orgu
1244: WHERE orgdef.organization_id = p_org_hierarchy_origin
1245: AND glstb.set_of_books_id = orgdef.set_of_books_id
1246: AND orgu.organization_id = orgdef.organization_id
1247: AND orgu.business_group_id = orgdef.business_group_id ;

Line 1259: , hr_organization_units HOU

1255: , l_sob_period_type
1256: , l_org_from_date
1257: FROM
1258: MTL_PARAMETERS MP
1259: , hr_organization_units HOU
1260: , HR_ORGANIZATION_INFORMATION HOI
1261: , gl_sets_of_books glstb
1262: WHERE HOU.ORGANIZATION_ID = p_org_hierarchy_origin
1263: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID