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:
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)
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;