APPS.PA_BILLING_SETUP_UTILS SQL Statements

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

Line: 38

         SELECT invoice_format_id
           FROM pa_invoice_formats
          WHERE name = p_retention_inv_format_name;

Line: 47

          SELECT invoice_format_id
            INTO x_retention_inv_format_id
            FROM pa_invoice_formats
           WHERE invoice_format_id = p_retention_inv_format_id;

Line: 88

         SELECT invoice_format_id
           INTO x_retention_inv_format_id
           FROM pa_invoice_formats
          WHERE name = p_retention_inv_format_name;

Line: 152

     SELECT 'X'
       FROM pa_credit_receivers
      WHERE project_id = p_project_id
        AND credit_type_code  = p_credit_type
        AND person_id         = p_person_id
        AND NVL( TASK_ID, -1 ) = DECODE( p_task_id, NULL, -1, p_task_id )
        AND (p_effective_from_date BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, p_effective_from_date + 1)
             OR  p_effective_to_date BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, p_effective_to_date + 1)
             OR  START_DATE_ACTIVE BETWEEN p_effective_from_date AND NVL(p_effective_to_date, START_DATE_ACTIVE + 1))
        AND ( p_credit_receiver_id IS NULL OR credit_receiver_id <> p_credit_receiver_id );

Line: 210

     SELECT 'X'
       FROM pa_billing_assignments_all
      WHERE project_id = p_project_id
        AND NVL( active_flag , 'N' )   = 'Y'
        AND NVL( p_active_flag, 'N' )  = 'Y'
        AND NVL( top_task_id, -1 ) = DECODE( p_task_id, NULL, -1, p_task_id )
        AND billing_extension_id  = p_billing_extension_id
        AND ( p_billing_assignment_id IS NULL OR billing_assignment_id <> p_billing_assignment_id );

Line: 274

          SELECT person_id
            FROM pa_employees
           WHERE full_name = p_person_name;

Line: 284

          SELECT person_id
            INTO x_person_id
            FROM pa_employees
           WHERE person_id = p_person_id;

Line: 325

          SELECT person_id
            INTO x_person_id
            FROM pa_employees
           WHERE full_name = p_person_name;

Line: 377

    SELECT start_date, billing_cycle_id, billing_offset
      FROM pa_projects_all
     WHERE project_id = p_project_id;

Line: 558

          SELECT person_id
            FROM pa_employees
           WHERE employee_number = p_emp_number;

Line: 567

          SELECT person_id
            INTO x_person_id
            FROM pa_employees
           WHERE person_id = p_person_id;

Line: 608

          SELECT person_id
            INTO x_person_id
            FROM pa_employees
           WHERE employee_number = p_emp_number;

Line: 821

    SELECT NVL(ALLOW_SALES_CREDIT_FLAG, 'N') ALLOW_SALES_CREDIT_FLAG
       FROM RA_BATCH_SOURCES R,
            PA_IMPLEMENTATIONS S
      WHERE R.BATCH_SOURCE_ID  = S.INVOICE_BATCH_SOURCE_ID ;