1376: sp.employee_terms_id,
1377: sp.apply_advances_default
1378: FROM ap_system_parameters_all sp,
1379: financials_system_parameters fp,
1380: fnd_currencies f
1381: WHERE sp.base_currency_code = f.currency_code
1382: AND sp.org_id = l_org_id;
1383:
1384: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
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
3137: AND XL.code_combination_id = gcc.code_combination_id(+)
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
3688: AND XL.code_combination_id = gcc.code_combination_id(+)