APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 222: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

218: FROM (
219: SELECT emp.expense_check_address_flag, null vendor_id
220: FROM per_employees_x emp
221: WHERE emp.employee_id = p_employee_id
222: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
223: UNION ALL
224: SELECT emp.expense_check_address_flag, vendor_id
225: FROM per_cont_workers_current_x emp
226: WHERE emp.person_id = p_employee_id

Line 631: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;

627: l_valid VARCHAR2(1) := 'N';
628:
629: l_employee_id number;
630: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
631: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
632:
633: /*Bug 2690715 : variable declarations */
634:
635:

Line 663: l_employee_id := nvl(p_employee_id, AP_WEB_DB_HR_INT_PKG.getemployeeid);

659: */
660:
661: BEGIN
662:
663: l_employee_id := nvl(p_employee_id, AP_WEB_DB_HR_INT_PKG.getemployeeid);
664:
665: /* Bug 3916349/4042775 - comment
666: for i in c1(l_employee_id) loop
667: l_chart_of_accounts_id := i.chart_of_accounts_id;

Line 678: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

674: FROM (
675: SELECT emp.set_of_books_id, emp.default_code_combination_id
676: FROM per_employees_x emp
677: WHERE emp.employee_id = l_employee_id
678: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
679: UNION ALL
680: SELECT emp.set_of_books_id, emp.default_code_combination_id
681: FROM per_cont_workers_current_x emp
682: WHERE emp.person_id = l_employee_id