DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on HR_OPERATING_UNITS

Line 1665: FROM HR_OPERATING_UNITS hou, GL_SETS_OF_BOOKS gsob

1661: END;
1662: BEGIN
1663: SELECT gsob.NAME
1664: INTO sobhr
1665: FROM HR_OPERATING_UNITS hou, GL_SETS_OF_BOOKS gsob
1666: WHERE hou.ORGANIZATION_ID = oulist(i)
1667: AND gsob.SET_OF_BOOKS_ID = hou.SET_OF_BOOKS_ID;
1668: EXCEPTION
1669: WHEN OTHERS THEN

Line 2285: FROM HR_OPERATING_UNITS

2281: IF (doccat.ORG_ID = oulist(i) ) THEN
2282: BEGIN
2283: SELECT UNIQUE SET_OF_BOOKS_ID
2284: INTO sobhr
2285: FROM HR_OPERATING_UNITS
2286: WHERE ORGANIZATION_ID = doccat.ORG_ID;
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: sobhr := -1;

Line 2318: FROM HR_OPERATING_UNITS

2314: IF omdef = TRUE THEN
2315: BEGIN
2316: SELECT UNIQUE SET_OF_BOOKS_ID
2317: INTO sobhr
2318: FROM HR_OPERATING_UNITS
2319: WHERE ORGANIZATION_ID = doccat.ORG_ID;
2320: EXCEPTION
2321: WHEN OTHERS THEN
2322: sobhr := -1;

Line 2410: , HR_OPERATING_UNITS hou

2406: IF ( ptcount = 0 ) THEN
2407: SELECT gl.name
2408: INTO sob
2409: FROM GL_SETS_OF_BOOKS gl
2410: , HR_OPERATING_UNITS hou
2411: WHERE hou.organization_id = oulist(i)
2412: AND gl.set_of_books_id = hou.set_of_books_id;
2413: errLogged := writeError( entity, p_level, p_value, error_type, mesg_name,
2414: null, null, getOuName(oulist(i)), null, null, sob, null, null,

Line 3015: FROM HR_OPERATING_UNITS

3011: IF omcnt > 0 THEN
3012: BEGIN
3013: SELECT SET_OF_BOOKS_ID
3014: INTO sob
3015: FROM HR_OPERATING_UNITS
3016: WHERE ORGANIZATION_ID = oulist(i);
3017: EXCEPTION
3018: WHEN NO_DATA_FOUND THEN
3019: sob := -1;