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: BEGIN

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: BEGIN
423: -- 3176205: This query includes all workers except for terminated

Line 1570: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;

1566: RETURN BOOLEAN IS
1567:
1568: --------------------------------------------------------------------------------
1569: l_debugInfo varchar2(240);
1570: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;
1571: BEGIN
1572: l_debugInfo := 'Get Chart of Accounts ID';
1573:
1574: SELECT set_of_books_id

Line 1590: FROM gl_sets_of_books GS

1586:
1587: IF (l_emp_set_of_books_id IS NOT NULL) THEN
1588: SELECT GS.chart_of_accounts_id
1589: INTO p_chart_of_accounts_id
1590: FROM gl_sets_of_books GS
1591: WHERE GS.set_of_books_id=l_emp_set_of_books_id;
1592: ELSE
1593: RETURN FALSE;
1594: END IF;