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 653: gl_sets_of_books GS,

649: cursor c1(p_employee_id IN number) is
650: SELECT GS.chart_of_accounts_id,
651: HR.default_code_combination_id
652: FROM ap_system_parameters S,
653: gl_sets_of_books GS,
654: per_workforce_x HR
655: WHERE HR.person_id = p_employee_id
656: AND GS.set_of_books_id = S.set_of_books_id
657: AND S.set_of_books_id = nvl(HR.set_of_books_id,S.set_of_books_id)

Line 693: FROM gl_sets_of_books GS

689:
690: IF (l_emp_set_of_books_id is not null) THEN
691: SELECT GS.chart_of_accounts_id
692: INTO l_emp_chart_of_accounts_id
693: FROM gl_sets_of_books GS
694: WHERE GS.set_of_books_id = l_emp_set_of_books_id;
695:
696: IF (l_emp_chart_of_accounts_id <> l_ou_chart_of_accounts_id) THEN
697: p_valid := FALSE;