APPS.ICX_REQ_SUBMIT dependencies on HR_EMPLOYEES_CURRENT_V

Line 109: from HR_EMPLOYEES_CURRENT_V

105: and sysdate < nvl(hrl.inactive_date,sysdate + 1);
106:
107: cursor requestor_name(v_employee_id number) is
108: select full_name
109: from HR_EMPLOYEES_CURRENT_V
110: where employee_id = v_employee_id;
111:
112: cursor item_names(id number, org number) is
113: select concatenated_segments

Line 780: FROM HR_EMPLOYEES_CURRENT_V

776: and hrl.location_code = loc;
777:
778: cursor requester_check(v_req_name varchar2,v_org_id number) is
779: SELECT employee_id
780: FROM HR_EMPLOYEES_CURRENT_V
781: WHERE full_name = v_req_name
782: and organization_id = v_org_id;
783:
784: cursor get_preparer_org(v_preparer_id number) is

Line 786: FROM HR_EMPLOYEES_CURRENT_V

782: and organization_id = v_org_id;
783:
784: cursor get_preparer_org(v_preparer_id number) is
785: SELECT organization_id
786: FROM HR_EMPLOYEES_CURRENT_V
787: where employee_id = v_preparer_id;
788:
789: cursor get_line_count(v_cart_id number) is
790: SELECT count(1)

Line 800: from hr_employees_current_v hecv,

796: cursor acctBuild(v_cart_id number,v_cart_line_id number, v_emp_id number,
797: v_oo_id number) is
798: select hecv.default_code_combination_id employee_default_account_id,
799: msi.expense_account
800: from hr_employees_current_v hecv,
801: mtl_system_items msi,
802: icx_shopping_carts isc,
803: icx_shopping_cart_lines iscl
804: where msi.INVENTORY_ITEM_ID (+) = iscl.ITEM_ID

Line 830: FROM HR_EMPLOYEES_CURRENT_V

826: and nvl(org_id, -9999) = nvl(v_oo_id, -9999);
827:
828: cursor employee_check(approver varchar2) is
829: SELECT employee_id
830: FROM HR_EMPLOYEES_CURRENT_V
831: where full_name = approver;
832:
833: cursor line_ids(v_cart_id number) is
834: select cart_line_id from icx_shopping_cart_lines