APPS.HXC_HXCMISTC_XMLP_PKG SQL Statements

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

Line: 28

      SELECT
        PPF.FULL_NAME,
        NVL(PPF.EMPLOYEE_NUMBER
           ,PPF.NPW_NUMBER)
      FROM
        PER_PEOPLE_F PPF
      WHERE PPF.PERSON_ID = CP_PERSON_ID
        AND CP_EFFECTIVE_DATE between PPF.EFFECTIVE_START_DATE
        AND PPF.EFFECTIVE_END_DATE;

Line: 38

      SELECT
        PAY.PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F PAY
      WHERE PAY.PAYROLL_ID = CP_PAYROLL_ID
        AND CP_EFFECTIVE_DATE between PAY.EFFECTIVE_START_DATE
        AND PAY.EFFECTIVE_END_DATE;

Line: 46

      SELECT
        VENDOR_NAME
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = P_VENDOR_ID;

Line: 52

      SELECT
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
        AND LOOKUP_CODE = P_LOOKUP_CODE;

Line: 104

      SELECT
        MEANING
      INTO
        L_DEFINE_MEANING
      FROM
        HXC_LOOKUPS
      WHERE LOOKUP_TYPE = 'HXC_DEFINE_MISSING'
        AND LOOKUP_CODE = P_DEFINE_MISSING;

Line: 115

      SELECT
        NAME
      INTO
        P_APPLICATION_LABEL
      FROM
        HXC_TIME_RECIPIENTS
      WHERE TIME_RECIPIENT_ID = P_APPLICATION;

Line: 140

      SELECT
        LOCATION_CODE
      INTO
        P_LOCATION_LABEL
      FROM
        HR_LOCATIONS
      WHERE LOCATION_ID = P_LOCATION;

Line: 149

      SELECT
        NAME
      INTO
        P_ORGANIZATION_LABEL
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION;

Line: 165

      SELECT
        ASSIGNMENT_SET_NAME
      INTO
        P_ASSIGNMENT_SET_LABEL
      FROM
        HR_ASSIGNMENT_SETS
      WHERE ASSIGNMENT_SET_ID = P_PAYROLL_ASSIGNMENT_SET;

Line: 217

    PERSON_TYPE1 := 'and     ppf.effective_start_date = (select max(effective_start_date)
                                                        from   per_people_f
                                                        where  person_id = ppf.person_id
                                                        and effective_start_date <= :p_date_to
                    				    and effective_end_date >= :p_date_from
                    				    and ptu.person_id = person_id
                    				    and ptu.effective_start_date <= :p_date_to
                    				    and ptu.effective_end_date >= :p_date_from
                    				    and ppt.person_type_id = ptu.person_type_id
                                                        --and ppt.person_type_id   = person_type_id
                                                        and ppt.system_person_type in ' || L_PERSON_TYPE || ')';

Line: 306

        SELECT
          DECODE(SUBSTR(P_PREF_SPEC_LIST_OUT
                       ,(INSTR(P_PREF_SPEC_LIST_OUT
                            ,'|'
                            ,1
                            ,I) + 1)
                       ,(INSTR(P_PREF_SPEC_LIST_OUT
                            ,'|'
                            ,1
                            ,I + 1) - 1) - (INSTR(P_PREF_SPEC_LIST_OUT
                            ,'|'
                            ,1
                            ,I)))
                ,'null'
                ,''
                ,SUBSTR(P_PREF_SPEC_LIST_OUT
                      ,(INSTR(P_PREF_SPEC_LIST_OUT
                           ,'|'
                           ,1
                           ,I) + 1)
                      ,(INSTR(P_PREF_SPEC_LIST_OUT
                           ,'|'
                           ,1
                           ,I + 1) - 1) - (INSTR(P_PREF_SPEC_LIST_OUT
                           ,'|'
                           ,1
                           ,I))))
        INTO
          L_TCARD_REQ_ATTRI
        FROM
          DUAL;