APPS.IBU_ALERT_BIN SQL Statements

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

Line: 123

      select employee_id, customer_id, supplier_id
      into l_employee_id, l_customer_id, l_supplier_id
      from fnd_user
      Where user_id =  p_user_id;

Line: 129

          select resource_id
          into resource_id
          from jtf_rs_resource_extns a, fnd_user b
          where a.source_id = b.employee_id
          and a.category = 'EMPLOYEE'
          and b.user_id = p_user_id
          and ( (a.end_date_active is null ) Or (a.end_date_active  > sysdate) );

Line: 137

          select resource_id
          into resource_id
          from jtf_rs_resource_extns a, fnd_user b
          where a.source_id = b.customer_id
          and a.category = 'PARTY'
          and b.user_id = p_user_id
          and ( (a.end_date_active is null ) Or (a.end_date_active  > sysdate) );

Line: 145

          select resource_id
          into resource_id
          from jtf_rs_resource_extns a, fnd_user b
          where a.source_id = b.supplier_id
          and a.category = 'SUPPLIER_CONTACT'
          and b.user_id = p_user_id
          and ( (a.end_date_active is null ) Or (a.end_date_active  > sysdate) );

Line: 494

      select employee_id, customer_id, supplier_id
      into l_employee_id, l_customer_id, l_supplier_id
      from fnd_user
      Where user_id =  l_user_id;

Line: 500

          select resource_id
          into resource_id
          from jtf_rs_resource_extns a, fnd_user b
          where a.source_id = b.employee_id
          and a.category = 'EMPLOYEE'
          and b.user_id = l_user_id
          and ( (a.end_date_active is null ) Or (a.end_date_active  > sysdate) );

Line: 508

          select resource_id
          into resource_id
          from jtf_rs_resource_extns a, fnd_user b
          where a.source_id = b.customer_id
          and a.category = 'PARTY'
          and b.user_id = l_user_id
          and ( (a.end_date_active is null ) Or (a.end_date_active  > sysdate) );

Line: 516

          select resource_id
          into resource_id
          from jtf_rs_resource_extns a, fnd_user b
          where a.source_id = b.supplier_id
          and a.category = 'SUPPLIER_CONTACT'
          and b.user_id = l_user_id
          and ( (a.end_date_active is null ) Or (a.end_date_active  > sysdate) );