[Home] [Help]
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
34: and hou.organization_id(+) = aeh.org_id
54: FROM
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
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
126: and ai.invoice_id = aeh.vouchno
151: ap_expense_report_headers_all aeh,
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
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;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
187: l_per_prepay NUMBER;
188: l_prepay_applied NUMBER;
189: l_vouchno NUMBER;
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;
1601: h.location_id,
1602: 'Y' is_contingent
1603: FROM PER_CONT_WORKERS_CURRENT_X h) emps,
1604: ap_suppliers V
1605: --ap_lookup_codes l1
1606: WHERE vouchno = 0
1607: AND XH.employee_id = V.employee_id(+)
1608: AND XH.employee_id = emps.employee_id(+)
1609: AND (trunc(sysdate) between people.effective_start_date(+) AND
3128: '' accounting_date,
3129: XL.org_id org_id
3130: FROM ap_expense_report_lines XL,
3131: gl_code_combinations gcc,
3132: ap_lookup_codes lc,
3133: fnd_currencies F,
3134: ap_expense_report_headers XH
3135: WHERE XL.report_header_id = XH.report_header_id
3136: AND XH.report_header_id = p_report_header_id
3679: ,xl.end_expense_date
3680: --bug 8658097 ends
3681: FROM ap_expense_report_lines XL,
3682: gl_code_combinations gcc,
3683: ap_lookup_codes lc,
3684: fnd_currencies F,
3685: ap_expense_report_headers XH
3686: WHERE XL.report_header_id = XH.report_header_id
3687: AND XH.report_header_id = p_report_header_id