[Home] [Help]
1375: sp.employee_pay_group_lookup_code,
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:
1610: people.effective_end_date(+))
1611: AND ((emps.business_group_id IS NULL) OR
1612: (emps.business_group_id in
1613: (SELECT nvl(FSP.business_group_id, 0)
1614: FROM financials_system_parameters FSP)))
1615: AND emps.employee_id = people.person_id(+)
1616: AND emps.location_id = locs.location_id(+)
1617: AND decode(XH.source,
1618: 'CREDIT CARD',
1652: validation_failed EXCEPTION;
1653: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
1659: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
1660: l_min_accountable_unit NUMBER;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
1659: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
1660: l_min_accountable_unit NUMBER;
1661: l_precision NUMBER;
1662: vendor_valid_flag VARCHAR2(2);
1663: vendor_site_valid_flag VARCHAR2(2);