DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on GL_SETS_OF_BOOKS

Line 129: gl_sets_of_books GS

125: BEGIN
126: select GS.chart_of_accounts_id
127: into p_chart_of_accounts
128: from ap_system_parameters S,
129: gl_sets_of_books GS
130: where GS.set_of_books_id = S.set_of_books_id;
131:
132: return TRUE;
133:

Line 676: gl_sets_of_books GS,

672: cursor c1(p_employee_id IN number) is
673: SELECT GS.chart_of_accounts_id,
674: HR.default_code_combination_id
675: FROM ap_system_parameters S,
676: gl_sets_of_books GS,
677: per_workforce_x HR
678: WHERE HR.person_id = p_employee_id
679: AND GS.set_of_books_id = S.set_of_books_id
680: AND S.set_of_books_id = nvl(HR.set_of_books_id,S.set_of_books_id)

Line 716: FROM gl_sets_of_books GS

712:
713: IF (l_emp_set_of_books_id is not null) THEN
714: SELECT GS.chart_of_accounts_id
715: INTO l_emp_chart_of_accounts_id
716: FROM gl_sets_of_books GS
717: WHERE GS.set_of_books_id = l_emp_set_of_books_id;
718:
719: IF (l_emp_chart_of_accounts_id <> l_ou_chart_of_accounts_id) THEN
720: p_valid := FALSE;