[Home] [Help]
262: sp.employee_pay_group_lookup_code,
263: sp.employee_terms_id,
264: sp.apply_advances_default
265: FROM ap_system_parameters_all sp,
266: financials_system_parameters fp,
267: fnd_currencies f
268: WHERE sp.base_currency_code = f.currency_code
269: AND sp.org_id = l_org_id;
270:
494: people.effective_end_date(+))
495: AND ((emps.business_group_id IS NULL) OR
496: (emps.business_group_id in
497: (SELECT nvl(FSP.business_group_id, 0)
498: FROM financials_system_parameters FSP)))
499: AND emps.employee_id = people.person_id(+)
500: AND emps.location_id = locs.location_id(+)
501: AND decode(XH.source,
502: 'CREDIT CARD',
537: validation_failed EXCEPTION;
538: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
539: l_base_currency ap_system_parameters.base_currency_code%TYPE;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
544: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
545: l_min_accountable_unit NUMBER;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
544: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
545: l_min_accountable_unit NUMBER;
546: l_precision NUMBER;
547: vendor_valid_flag VARCHAR2(2);
548: vendor_site_valid_flag VARCHAR2(2);