DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 323: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

319: C_Distribution_Set_ID NUMBER;
320: C_quantity_outstanding NUMBER;
321: C_overbilled VARCHAR2(1);
322: C_Quantity NUMBER;
323: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;

Line 324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

320: C_quantity_outstanding NUMBER;
321: C_overbilled VARCHAR2(1);
322: C_Quantity NUMBER;
323: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;

Line 810: ap_system_parameters sp,

806: P_approval_workflow_flag,
807: P_inventory_org_id,
808: P_ship_to_location_id
809: FROM po_vendors v,
810: ap_system_parameters sp,
811: po_vendor_sites vs,
812: financials_system_parameters fsp
813: WHERE v.vendor_id = P_vendor_id
814: AND vs.org_id = sp.org_id

Line 1257: FROM ap_system_parameters;

1253: debug_info := 'Get WF Approval option';
1254: BEGIN
1255: SELECT approval_workflow_flag
1256: INTO l_use_workflow_flag
1257: FROM ap_system_parameters;
1258:
1259: SELECT approval_required_flag
1260: INTO l_approval_required_flag
1261: FROM ap_recurring_payments_all