APPS.PSP_PSPENAWD_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        COUNT(1)
      FROM
        PSP_REPORT_TEMPLATE_DETAILS
      WHERE TEMPLATE_ID = P_TEMPLATE_ID
        AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
        AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;

Line: 23

        P_AWARD_ID := ' and gaa.award_id  IN (select criteria_value1 from psp_report_template_details
                               where template_id = ' || P_AWD_TEMPLATE_ID || '
                               and   criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
                               and   criteria_lookup_code = ''AWD'' ' || ' ) ';

Line: 39

        P_PAYROLL_ID := ' and pelh.payroll_id IN (select criteria_value1 from psp_report_template_details
                               where template_id = ' || P_PAY_TEMPLATE_ID || '
                               and   criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
                               and   criteria_lookup_code = ''PAY'' ' || ' ) ';

Line: 60

    SELECT
      NAME
    INTO L_PROJECT_NAME
    FROM
      PA_PROJECTS_ALL
    WHERE PROJECT_ID = CF_CHARGING_INSTFORMULA.PROJECT_ID;

Line: 66

    SELECT
      TASK_NUMBER
    INTO L_TASK_NUMBER
    FROM
      PA_TASKS
    WHERE TASK_ID = CF_CHARGING_INSTFORMULA.TASK_ID;

Line: 72

    SELECT
      AWARD_NUMBER
    INTO L_AWARD_NUMBER
    FROM
      GMS_AWARDS_ALL
    WHERE AWARD_ID = CF_CHARGING_INSTFORMULA.AWARD_ID;

Line: 78

    SELECT
      NAME
    INTO L_ORG_NAME
    FROM
      HR_ALL_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;

Line: 94

      SELECT
        GA.END_DATE_ACTIVE
      FROM
        GMS_AWARDS GA
      WHERE GA.AWARD_ID = CF_AWD_END_DTFORMULA.AWARD_ID;