DBA Data[Home] [Help]

APPS.PAY_US_SQWL_MISC SQL Statements

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

Line: 43

  select value
    from ff_archive_items fai,
         ff_user_entities fue
   where context1 = p_asact_ctx_id
     and fue.user_entity_id = fai.user_entity_id
     and fue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_3';
Line: 82

  select value
    from ff_archive_items fai,
         ff_user_entities fue
   where context1 = p_asact_ctx_id
     and fue.user_entity_id = fai.user_entity_id
     and fue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_2';
Line: 121

  select value
    from ff_archive_items fai,
         ff_user_entities fue
   where context1 = p_asact_ctx_id
     and fue.user_entity_id = fai.user_entity_id
     and fue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_1';