APPS.CN_GET_COMM_PMT_PAID_GRP SQL Statements

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

Line: 15

    SELECT gsob.currency_code from_currency
    FROM cn_repositories_all repo,
        gl_sets_of_books gsob
    WHERE repo.org_id = p_org_id
    AND repo.application_id = 283
    AND repo.set_of_books_id = gsob.set_of_books_id;

Line: 67

    SELECT (p_end_date - p_start_date + 1) prorated_days
    FROM dual;

Line: 124

    SELECT rs.org_id, rs.salesrep_id, hou.name operating_unit
    FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,
    hr_operating_units hou
    WHERE rre.source_id = p_person_id
    AND rre.resource_id = rs.resource_id
    AND rre.category = 'EMPLOYEE'
    AND rs.org_id = hou.organization_id;

Line: 136

    SELECT min(period_id) start_period_id, max(period_id) end_period_id,
           min(start_date) new_start_date, max(end_date) new_end_date,
           (max(end_date) - min(start_date) + 1) total_days
    FROM cn_period_statuses_all
    WHERE start_date <= p_end_date
    AND p_start_date <= end_date
    AND org_id = p_org_id
    ORDER BY period_id;

Line: 150

    SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
           NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt
    FROM cn_srp_periods_all
    WHERE salesrep_id = p_salesrep_id
    AND period_id BETWEEN p_start_period_id AND p_end_period_id
    AND credit_type_id = g_credit_type_id
    AND quota_id IS NULL
    AND org_id = p_org_id;