DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on GL_SETS_OF_BOOKS

Line 1646: FROM AR_SYSTEM_PARAMETERS_ALL aspa, GL_SETS_OF_BOOKS gsob

1642: BEGIN
1643: IF oe_code_control.code_release_level < '110510' THEN
1644: SELECT gsob.NAME
1645: INTO sobar
1646: FROM AR_SYSTEM_PARAMETERS_ALL aspa, GL_SETS_OF_BOOKS gsob
1647: WHERE aspa.ORG_ID = oulist(i)
1648: AND gsob.SET_OF_BOOKS_ID = aspa.SET_OF_BOOKS_ID;
1649: ELSE
1650: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(oulist(i));

Line 1654: FROM GL_SETS_OF_BOOKS gsob

1650: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(oulist(i));
1651: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
1652: SELECT gsob.NAME
1653: INTO sobar
1654: FROM GL_SETS_OF_BOOKS gsob
1655: WHERE gsob.SET_OF_BOOKS_ID = l_sob_id;
1656: END IF;
1657:
1658: EXCEPTION

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 2409: FROM GL_SETS_OF_BOOKS gl

2405: mesg_name := 'ONT_SETVAL_CC_INVALID_PAY_TERM';
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,