APPS.PAY_US_ARCHIVE_UTIL SQL Statements

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

Line: 59

         SELECT user_entity_id
           FROM ff_user_entities
          WHERE user_entity_name = cp_user_entity_name;

Line: 70

         SELECT fai.VALUE
           FROM ff_archive_items fai, ff_archive_item_contexts fic
          WHERE fai.context1 = cp_action_id
            AND fai.user_entity_id = cp_user_entity_id
            AND fai.archive_item_id = fic.archive_item_id
            AND fic.context_id = cp_tax_context_id
            AND fic.CONTEXT = cp_tax_unit_id;

Line: 87

         SELECT fai.VALUE
           FROM ff_archive_item_contexts faic2,
                ff_archive_item_contexts faic1,
                ff_contexts fc2,
                ff_contexts fc1,
                ff_archive_items fai
          WHERE fai.user_entity_id = cp_user_entity_id
            AND fai.context1 = cp_action_id
            AND fc2.context_name = 'TAX_UNIT_ID'
            AND fc1.context_name = 'JURISDICTION_CODE'
            AND fai.archive_item_id = faic2.archive_item_id
            AND faic2.context_id = fc2.context_id
            AND faic2.CONTEXT = cp_tax_unit_id
            AND fai.archive_item_id = faic1.archive_item_id
            AND faic1.context_id = fc1.context_id
            AND substr(faic1.CONTEXT,1,2) = substr(cp_jurisdiction_code,1,2);