APPS.AP_WEB_EXPORT_ER dependencies on PER_EMPLOYEES_X

Line 29: per_employees_x per,

25: FROM
26: ap_expense_report_headers_all aeh,
27: ap_suppliers aps,
28: ap_suppliers apsbp,
29: per_employees_x per,
30: ap_lookup_codes alc,
31: hr_organization_units hou
32: where aeh.request_id = l_req_id
33: and aeh.reject_code is not null

Line 121: per_employees_x per,

117: ap_expense_report_headers_all aeh,
118: ap_invoices_all ai,
119: ap_suppliers aps,
120: ap_suppliers apsbp,
121: per_employees_x per,
122: ap_lookup_codes alc,
123: hr_organization_units hou
124: where aeh.request_id = l_req_id
125: and nvl(aeh.vouchno, 0) > 0

Line 172: l_full_name per_employees_x.full_name%TYPE;

168:
169: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
170: l_export_message VARCHAR2(100);
171: l_count NUMBER := 0;
172: l_full_name per_employees_x.full_name%TYPE;
173: l_emp_num per_employees_x.employee_num%TYPE;
174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;

Line 173: l_emp_num per_employees_x.employee_num%TYPE;

169: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
170: l_export_message VARCHAR2(100);
171: l_count NUMBER := 0;
172: l_full_name per_employees_x.full_name%TYPE;
173: l_emp_num per_employees_x.employee_num%TYPE;
174: l_vendor_name ap_suppliers.vendor_name%TYPE;
175: l_vendor_num ap_suppliers.segment1%TYPE;
176: l_inv_num ap_expense_report_headers_all.invoice_num%TYPE;
177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;

Line 1590: FROM per_employees_x h

1586: h.first_name,
1587: h.business_group_id,
1588: h.location_id,
1589: 'N' is_contingent
1590: FROM per_employees_x h
1591: WHERE AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='N'
1592: UNION ALL
1593: SELECT
1594: h.person_id employee_id,

Line 3852: FROM per_employees_x

3848: WHERE vendor_site_id = l_vendor_site_id;
3849:
3850: CURSOR c_party_id(l_employee_id IN NUMBER) IS
3851: SELECT party_id
3852: FROM per_employees_x
3853: WHERE employee_id = l_employee_id
3854: AND rownum = 1;
3855:
3856: --Bug#7012808 - Payment Priority Defaulted to 99