APPS.OKS_OKSSUMRP_XMLP_PKG SQL Statements

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

Line: 18

    SELECT
      DISTINCT
      NAME
    INTO L_REP_NAME
    FROM
      JTF_RS_SALESREPS
    WHERE SALESREP_ID = REP_NAME1
      AND ORG_ID = CF_1FORMULA.ORG_ID
      AND ROWNUM < 2;

Line: 40

      SELECT
        MAX(B.INT_END_DATE)
      FROM
        OKC_LAUNCH_COMMGRID_V B,
        OKC_K_HEADERS_B A
      WHERE A.ID = CONTRACT_ID
        AND A.ID = B.CONTRACT_ID
        AND ROWNUM < 2;

Line: 102

      P_CONTRACT_GROUP_WHERE := ' and contract_id in ( select INCLUDED_CHR_ID from okc_k_grpings
                                                                                    start with CGP_PARENT_ID = :p_contract_group
                                                                                    connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID ) ';