APPS.PO_WF_PO_ACCRUAL_ACC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 98

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 153

	select ap_accrual_account into x_account
	from mtl_parameters
	where organization_id     = x_dest_org_id;

Line: 157

	select accrued_code_combination_id into x_account
  	from po_system_parameters;

Line: 216

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 268

	select accrued_code_combination_id into x_account
  	from po_system_parameters;

Line: 368

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
           'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account ' ||
           'l_purchasing_ou_id='||l_purchasing_ou_id);

Line: 376

    SELECT accrued_code_combination_id
    INTO l_account_id
    FROM PO_SYSTEM_PARAMETERS_ALL
    WHERE org_id = l_purchasing_ou_id;

Line: 401

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
           'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account result='||result);

Line: 403

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account l_account_id='||
         l_account_id);

Line: 410

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account EXCEPTION at '||
         l_progress);