APPS.AP_WEB_DB_EXPRPT_PKG dependencies on GL_SETS_OF_BOOKS

Line 418: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;

414: Added GS.set_of_books_id=nvl(HR.set_of_books_id,
415: GS.set_of_books_id)
416: to avoid Merge join cartesians.
417: */
418: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;
419: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
420: l_exp_check_address_flag per_employees_x.expense_check_address_flag%type;
421: l_fin_exp_check_address_flag financials_system_parameters.expense_check_address_flag%type;
422: l_default_exch_rate_type apSetUp_defaultExchRateType;

Line 419: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

415: GS.set_of_books_id)
416: to avoid Merge join cartesians.
417: */
418: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;
419: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
420: l_exp_check_address_flag per_employees_x.expense_check_address_flag%type;
421: l_fin_exp_check_address_flag financials_system_parameters.expense_check_address_flag%type;
422: l_default_exch_rate_type apSetUp_defaultExchRateType;
423: BEGIN

Line 1584: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;

1580: RETURN BOOLEAN IS
1581:
1582: --------------------------------------------------------------------------------
1583: l_debugInfo varchar2(240);
1584: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;
1585: BEGIN
1586: l_debugInfo := 'Get Chart of Accounts ID';
1587:
1588: SELECT set_of_books_id

Line 1604: FROM gl_sets_of_books GS

1600:
1601: IF (l_emp_set_of_books_id IS NOT NULL) THEN
1602: SELECT GS.chart_of_accounts_id
1603: INTO p_chart_of_accounts_id
1604: FROM gl_sets_of_books GS
1605: WHERE GS.set_of_books_id=l_emp_set_of_books_id;
1606: ELSE
1607: RETURN FALSE;
1608: END IF;