APPS.XLE_UPGRADE_UTILS dependencies on XLE_SOB_INTERFACE

Line 44: cursor acct_env_type(l_sob_id IN NUMBER) is select accounting_env_type from xle_sob_interface where set_of_books_id = l_sob_id;

40: AND o2.org_information1 = 'OPERATING_UNIT'
41: AND o2.org_information2 = 'Y'
42: AND o.organization_id = p_org_id;
43:
44: cursor acct_env_type(l_sob_id IN NUMBER) is select accounting_env_type from xle_sob_interface where set_of_books_id = l_sob_id;
45:
46: cursor def_legal_context(l_sob_id IN VARCHAR2) is select legal_entity_Id from xle_le_sob_interface where set_of_books_id = l_sob_id;
47:
48: cursor check_le(p_org_Id IN NUMBER) is select legal_entity_id from xle_le_ou_interface where organization_id = p_org_id;

Line 99: --Get accounting_env_type from xle_sob_interface

95: CLOSE get_sob_id;
96:
97:
98:
99: --Get accounting_env_type from xle_sob_interface
100:
101: OPEN acct_env_type(l_sob_id);
102: FETCH acct_env_type into l_acct_env_type;
103: IF acct_env_type%NOTFOUND THEN