APPS.PAY_US_ADHOC_UTILS SQL Statements

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

Line: 75

	      select nvl(value,'N') into v_nr_flag
	      from   ff_database_items fdi,
	             ff_archive_items fai
              where user_name = 'A_IN_NR_FLAG'
              and fdi.user_entity_id = fai.user_entity_id
              and fai.context1 = p_assig_action_id;

Line: 84

                   select nvl(value,'00-000-0000') into v_nr_jd
                   from   ff_database_items fdi,
                          ff_archive_items fai
                   where  fdi.user_name = 'A_IN_RES_JD'
                          and fdi.user_entity_id = fai.user_entity_id
                          and context1 = p_assig_action_id;

Line: 137

       SELECT FEDERAL_EIN into v_name
       from pay_us_w2_tax_unit_v
       where TAX_UNIT_ID = p_commonpay_agent_id
       and   year        = p_year;

Line: 144

      SELECT tax_unit_name into v_name
      from pay_us_w2_tax_unit_v
      where TAX_UNIT_ID = p_commonpay_agent_id
      and   year        = p_year;