APPS.PA_MULTI_ORG SQL Statements

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

Line: 15

    x_stage := 'SELECT ORG_ID FROM PA_IMPLEMENTATIONS';

Line: 16

    SELECT  org_id
      INTO  x_org_id
      FROM  pa_implementations;

Line: 21

    x_stage := 'INSERT INTO PA_FUNCTION_TRANSACTIONS';

Line: 22

    INSERT INTO pa_function_transactions(
       application_id
    ,  function_code
    ,  function_transaction_code
    ,  function_transaction_name
    ,  last_update_date
    ,  last_updated_by
    ,  creation_date
    ,  created_by
    ,  last_update_login
    ,  enabled_flag
    ,  description
    ,  org_id )
    SELECT
     	    ft.application_id
    ,       ft.function_code
    ,       ft.function_transaction_code
    ,       ft.function_transaction_name
    ,       sysdate
    ,       x_user
    ,       sysdate
    ,       x_user
    ,       x_login
    ,       ft.enabled_flag
    ,       ft.description
    ,       x_org_id
      FROM  pa_function_transactions_all ft
     WHERE  org_id = -3113
    AND NOT EXISTS (
       SELECT NULL
         FROM pa_function_transactions
        WHERE org_id = x_org_id
          AND application_id = ft.application_id
          AND function_code = ft.function_code
          AND function_transaction_code = ft.function_transaction_code );

Line: 61

    x_stage := 'INSERT INTO PA_BILLING_ASSIGNMENTS';

Line: 62

    INSERT INTO pa_billing_assignments(
       billing_assignment_id
    ,  billing_extension_id
    ,  project_type
    ,  project_id
    ,  top_task_id
    ,  amount
    ,  percentage
    ,  active_flag
    ,  last_update_date
    ,  last_updated_by
    ,  creation_date
    ,  created_by
    ,  last_update_login
    ,  distribution_rule
    ,  org_id )
    SELECT
            pa_billing_assignments_s.NEXTVAL
    ,       ba.billing_extension_id
    ,       ba.project_type
    ,       ba.project_id
    ,       ba.top_task_id
    ,       ba.amount
    ,       ba.percentage
    ,       ba.active_flag
    ,       sysdate
    ,       x_user
    ,       sysdate
    ,       x_user
    ,       x_login
    ,       ba.distribution_rule
    ,       x_org_id
      FROM  pa_billing_assignments_all ba
     WHERE  org_id = -3113
    AND NOT EXISTS (
       SELECT NULL
         FROM pa_billing_assignments
        WHERE org_id = x_org_id
          AND distribution_rule = ba.distribution_rule
          AND billing_extension_id = ba.billing_extension_id
          AND project_type = ba.project_type
          AND project_id = ba.project_id
          AND top_task_id = ba.top_task_id );