[Home] [Help]
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
34: and hou.organization_id(+) = aeh.org_id
35: and per.employee_id = aeh.employee_id
55: ap_expense_report_headers_all aeh,
56: ap_suppliers aps,
57: per_cont_workers_x per,
58: ap_lookup_codes alc,
59: hr_organization_units hou
60: where aeh.request_id = l_req_id
61: and aeh.reject_code is not null
62: and hou.organization_id(+) = aeh.org_id
63: and per.person_id = aeh.employee_id
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,
85: ap_expense_report_headers_all aeh, hr_organization_units hou
86: WHERE aeh.request_id = l_req_id
87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id
89: AND I.invoice_id = aeh.vouchno
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
126: and ai.invoice_id = aeh.vouchno
127: and aeh.reject_code is null
152: ap_invoices_all ai,
153: ap_suppliers aps,
154: per_cont_workers_x per,
155: ap_lookup_codes alc,
156: hr_organization_units hou
157: where aeh.request_id = l_req_id
158: and nvl(aeh.vouchno, 0) > 0
159: and ai.invoice_id = aeh.vouchno
160: and aeh.reject_code is null
190: l_exp_desc ap_expense_report_headers_all.description%TYPE;
191: l_hold ap_lookup_codes.description%TYPE;
192: l_org_id NUMBER;
193: l_prev_org_id NUMBER;
194: l_org_name hr_organization_units.name%TYPE;
195: l_print_header BOOLEAN := TRUE;
196: l_page_count NUMBER;
197: l_base_currency ap_system_parameters_all.base_currency_code%TYPE;
198: l_default_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;