APPS.JA_JAINITCR_XMLP_PKG SQL Statements

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

Line: 32

    SELECT
      ' ' || LC1.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
      ' ' || LC2.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
      ' ' || LC3.meaning || ' ', --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
      ' ' || LC4.meaning  --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
    INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
    FROM
      ja_lookups LC1, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
      ja_lookups LC2, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
      ja_lookups LC3, --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
      ja_lookups LC4 --Changed from ap_lookup_codes to ja_lookups for Bug#5930605
    WHERE LC1.LOOKUP_CODE = 'CRORE'
      AND LC1.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' --Modified for bug# 5930605
      AND LC2.LOOKUP_CODE = 'LAKH'
      AND LC2.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' -- Modified for bug# 5930605
      AND LC3.LOOKUP_CODE = 'THOUSAND'
      AND LC3.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION' -- Modified for bug# 5930605
      AND LC4.LOOKUP_CODE = 'ZERO'
      AND LC4.LOOKUP_TYPE = 'JAI_NLS_TRANSLATION'; -- Modified for bug# 5930605

Line: 97

    UPDATE
      JAI_AP_TDS_F16_HDRS_ALL
    SET
      ISSUE_DATE = SYSDATE
      ,PRINT_FLAG = 'Y'
    WHERE CERTIFICATE_NUM >= NVL(P_CERTIFICATE_START_NO
       ,CERTIFICATE_NUM)
      AND CERTIFICATE_NUM <= NVL(P_CERTIFICATE_END_NO
       ,CERTIFICATE_NUM)
      AND VENDOR_ID = NVL(P_VENDOR_ID
       ,VENDOR_ID)
      AND TRUNC(FROM_DATE) >= NVL(P_FROM_DATE
       ,TRUNC(FROM_DATE))
      AND TRUNC(TO_DATE) <= NVL(P_TO_DATE
       ,TRUNC(TO_DATE));

Line: 129

      SELECT
        ATTRIBUTE2
      FROM
        AP_CHECKS_ALL
      WHERE ATTRIBUTE3 = C_CHQ
        AND ATTRIBUTE_CATEGORY = 'India Payment Information'
        AND CHECK_ID in (
        SELECT
          CHECK_ID
        FROM
          AP_INVOICE_PAYMENTS_ALL
        WHERE INVOICE_ID = TDS_INVOICE_ID );

Line: 151

        SELECT
          BANK_NAME,
          BANK_BRANCH_NAME,
          ADDRESS_LINE1,
          ADDRESS_LINE2,
          ADDRESS_LINE3,
          CITY
        INTO P_BANK_NAME,P_BANK_BRANCH_NAME,P_ADD1,P_ADD2,P_ADD3,P_CITY
        FROM
          AP_BANK_BRANCHES
        WHERE BANK_BRANCH_ID in (
          SELECT
            BANK_BRANCH_ID
          FROM
            AP_BANK_ACCOUNTS_ALL
          WHERE BANK_ACCOUNT_ID IN (
            SELECT
              DISTINCT
              EXTERNAL_BANK_ACCOUNT_ID
            FROM
              AP_BANK_ACCOUNT_USES_ALL
            WHERE PRIMARY_FLAG = 'Y'
              AND VENDOR_ID = TDS_ID ) );

Line: 200

      SELECT
        NAME
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 217

    SELECT
      DECODE(HOU.LOCATION_ID
            ,NULL
            ,HOU.INTERNAL_ADDRESS_LINE
            ,LOC.ADDRESS_LINE_1 || ',' || LOC.ADDRESS_LINE_2 || ',' || LOC.ADDRESS_LINE_3 || ',' || LOC.TOWN_OR_CITY || ',' || LOC.POSTAL_CODE || ',' || LOC.COUNTRY)
    INTO V_ADDRESS1
    FROM
      HR_ORGANIZATION_UNITS HOU,
      HR_LOCATIONS LOC
    WHERE HOU.ORGANIZATION_ID = P_ORGANIZATION_ID
      AND HOU.LOCATION_ID = loc.location_id (+);

Line: 242

      SELECT
        PAN_NO
      FROM
        JAI_AP_TDS_VENDOR_HDRS
      WHERE VENDOR_ID = P_VEN_ID;

Line: 257

      SELECT
        CHECK_DEPOSIT_DATE
      FROM
        JAI_AP_TDS_PAYMENTS APC,
        JAI_AP_TDS_F16_HDRS_ALL AFRM
      WHERE CHECK_NUMBER = CHQ
        AND APC.VENDOR_ID = AFRM.TAX_AUTHORITY_ID;

Line: 284

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 292

      SELECT
        A.SID,
        A.SERIAL#,
        B.SPID
      FROM
        V$SESSION A,
        V$PROCESS B
      WHERE AUDSID = USERENV('SESSIONID')
        AND A.PADDR = B.ADDR;

Line: 302

      SELECT
        NAME
      FROM
        V$DATABASE;

Line: 347

  FUNCTION F_SELECTED_CERT_DATE RETURN VARCHAR2 IS
    RET_TEXT VARCHAR2(1000) := NULL;

Line: 365

  END F_SELECTED_CERT_DATE;

Line: 367

  FUNCTION F_SELECTED_CERT_ID RETURN VARCHAR2 IS
    RET_TEXT VARCHAR2(1000) := NULL;

Line: 385

  END F_SELECTED_CERT_ID;

Line: 387

  FUNCTION F_SELECTED_VENDOR RETURN VARCHAR2 IS
    RET_TEXT VARCHAR2(1000) := NULL;

Line: 400

  END F_SELECTED_VENDOR;

Line: 404

    P_SELECTED_VENDOR := F_SELECTED_VENDOR;

Line: 405

    P_SELECTED_CERT_ID := F_SELECTED_CERT_ID;

Line: 406

    P_SELECTED_CERT_DATE := F_SELECTED_CERT_DATE;

Line: 413

      SELECT
        JATP.TDS_TAX_ID
      FROM
        JAI_AP_TDS_INV_PAYMENTS JATP
      WHERE JATP.INVOICE_ID = TDS_INVOICE_ID;

Line: 419

      SELECT
        ( NVL(TAX_RATE
           ,0) - ( NVL(SURCHARGE_RATE
           ,0) + NVL(CESS_RATE
           ,0) ) ) TDS_RATE,
        NVL(SURCHARGE_RATE
           ,0) SURCHARGE_RATE,
        NVL(CESS_RATE
           ,0),
        NVL(SH_CESS_RATE
           ,0),
        NVL(TAX_RATE
           ,0)
      FROM
        JAI_CMN_TAXES_ALL JTC
      WHERE TAX_ID = P_TAX_ID;

Line: 467

      SELECT
        A.BANK_NUM
      FROM
        AP_BANK_BRANCHES A,
        AP_BANK_ACCOUNTS_ALL B
      WHERE A.BANK_BRANCH_ID = B.BANK_BRANCH_ID
        AND B.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID;