DBA Data[Home] [Help]

APPS.AP_APXTRSWP_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 22: FROM gl_sets_of_books sob

18:
19: begin
20: SELECT nvl(sob.sla_ledger_cash_basis_flag, 'N')
21: INTO cash_acct_flag
22: FROM gl_sets_of_books sob
23: WHERE sob.set_of_books_id = p_set_of_books_id;
24: exception
25: when no_data_found then
26: null;

Line 320: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

316: END; return (TRUE);
317: end;
318:
319: FUNCTION get_company_name RETURN BOOLEAN IS
320: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
321: l_name gl_sets_of_books.name%TYPE;
322: l_sob_id number;
323: BEGIN
324:

Line 321: l_name gl_sets_of_books.name%TYPE;

317: end;
318:
319: FUNCTION get_company_name RETURN BOOLEAN IS
320: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
321: l_name gl_sets_of_books.name%TYPE;
322: l_sob_id number;
323: BEGIN
324:
325: if P_SET_OF_BOOKS_ID is not null then

Line 331: FROM gl_sets_of_books

327: SELECT name,
328: chart_of_accounts_id
329: INTO l_name,
330: l_chart_of_accounts_id
331: FROM gl_sets_of_books
332: WHERE set_of_books_id = l_sob_id;
333:
334: c_company_name_header := l_name;
335: c_chart_of_accounts_id := l_chart_of_accounts_id;

Line 562: GL_SETS_OF_BOOKS SOB

558: FROM HR_ORGANIZATION_INFORMATION OI,
559: HR_ALL_ORGANIZATION_UNITS_TL LE,
560: HR_ALL_ORGANIZATION_UNITS_TL OU,
561: AP_SYSTEM_PARAMETERS_ALL ASP,
562: GL_SETS_OF_BOOKS SOB
563: WHERE nvl(SOB.SLA_LEDGER_CASH_BASIS_FLAG, 'N') <> 'Y'
564: AND SOB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
565: AND ASP.ORG_ID = OI.ORGANIZATION_ID
566: AND OU.ORGANIZATION_ID = OI.ORGANIZATION_ID

Line 967: FROM gl_sets_of_books

963: BEGIN
964:
965: SELECT nvl(sla_ledger_cash_basis_flag, 'N')
966: INTO l_cash_basis_flag
967: FROM gl_sets_of_books
968: WHERE set_of_books_id = p_set_of_books_id;
969:
970: if (l_cash_basis_flag = 'N') then
971: c_accrual_basis_in_use := 'Y';